Can you please help me to load data of emojis( 🚫Invalid Labor ) in teradata i am using tpt scritp to read the data from hadoop to teradata stage tables , i am using " USING CHARACTER SET UTF8" in TPT , i have reffered teradata knoweldge base , i found below link i am also following same but i don't know why it is failing( in below link they mentioned use of case bteq script with smile emoji)
below is the error i am getting , my column character set is unicode
COLUMN_NAME VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC
6705 An illegally formed character string was encountered during translation.
terdata version : 16
please let me know if you need further information , appreciate your help
Solved! Go to Solution.
This is a 16.xx new feature so be sure to be in a supported version.
Look for Unicode Pass Through in docs.teradata.com, and UnicodePassThrough in the TPT Reference 16.20.