Chinese character not getting displayed correctly in SQL Workbench

Database
Visitor

Chinese character not getting displayed correctly in SQL Workbench

I am using SQL Workbench with latest teradata drivers and for Chinese character its showing data in an unidentified format.
I have attached the screenshot for same.

Screen Shot 2018-07-02 at 4.55.29 PM.png

1 REPLY
Teradata Employee

Re: Chinese character not getting displayed correctly in SQL Workbench

Are columns defined as UNICODE, and was data loaded with Unicode (UTF-8 or UTF-16) or a custom local session character set?

 

This is the sort of thing we typically see if the column was (misleadingly) defined as LATIN and loaded using ASCII session character set, then queried with UTF-8 / UTF-16 or custom session character set.