unicode

Tools & Utilities
Teradata Employee

unicode

As we are receiving junk characters from Oracel as Osnabr�Ck instead of osnabrück

We are also seeing junk data in teradata as Osnabr�Ck . We are using UTF8 in out TPT.Can we use unicode tool kit to overcome this issue or please let me know if there are any other ways to overcome the issue. (source data will not be changed).

 

Thanks,

Sai

4 REPLIES
Teradata Employee

Re: unicode

are you using TPT script or TPT wizerd ? 

Samar Kamal,
ETL Consultant
Tags (1)
Teradata Employee

Re: unicode

TPT script

Teradata Employee

Re: unicode

I think you should start your script with this line 

" USING CHARACTER SET UTF8"

Samar Kamal,
ETL Consultant
Teradata Employee

Re: unicode

We are using set UTF8 in our TPT script but still we are having the issue.