UNICODE ISSUE

Teradata Applications
Teradata Employee

UNICODE ISSUE

Hello

 

Can you help me in converting the string Wistron México, S.A. De C.V. to Wistron México, S.A. De C.V.

we are using TPT to load the STG table from Oracle.We are also using unicode in target table definition and also tried UTF8 in TPT but we are still unable to see the same text as in source.

 

Thanks,

Sai


Accepted Solutions
Teradata Employee

Re: UNICODE ISSUE

USING CHARACTER SET UTF8 in the TPT job script should work for this (whether the target column is LATIN or UNICODE).

 

Or look at the Unicode Tool Kit from developer.teradata.com for ways to translate after loading.

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: UNICODE ISSUE

USING CHARACTER SET UTF8 in the TPT job script should work for this (whether the target column is LATIN or UNICODE).

 

Or look at the Unicode Tool Kit from developer.teradata.com for ways to translate after loading.

Teradata Employee

Re: UNICODE ISSUE

Thank you. It worked fine using UTF 8 and Unicode