how to load emojis

Database
Enthusiast

how to load emojis

Hi ,

 

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)


http://knowledge.teradata.com/KCS/id/KCS017078

 

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

Tags (1)

Accepted Solutions
Enthusiast

Re: how to load emojis

thanks for your reference , i have palced below command in TPT scripts , it worked , appreciate your help

 

UnicodePassThrough = 'on'

1 ACCEPTED SOLUTION
2 REPLIES 2
Highlighted
Teradata Employee

Re: how to load emojis

Hi babaji001,

 

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.

 

Enthusiast

Re: how to load emojis

thanks for your reference , i have palced below command in TPT scripts , it worked , appreciate your help

 

UnicodePassThrough = 'on'