All Forums Connectivity
tsnr 3 posts Joined 09/09
03 Sep 2009
ODBC characters tarnslation issue

Hi ,I'm using ODBC driver for connecting Teradata V12 database from Siebel 7.8.2 application. I could able to retrieve the data but I'm not able getting the Chinese characters instead of English Characters.The Siebel application is on Solaris SPARC machine.Below is the odbc.ini file configurationDriver=tdata.soDescription=NCR 3600 running Teradata V1R5.2DBCName=TDDEVLastUser=Username=Password=Database =DefaultDatabase=Is there anything missing in above file?Any help/thoughts will be appreciated.ThanksSiva.

Jimm 298 posts Joined 09/07
04 Sep 2009

Is your username set up with a default character set of Unicode?

vhari 111 posts Joined 12/08
08 Sep 2009

- in your odbc.ini I do not see "Characterset" option, which represent the session's character-set. Since you did not specify anything, the default one is being used, which is ASCII. Suggest you to use one of the Teradata supported session-character-set for Chinese or UTF16(unicode) or UTF8(Unicode)Ex : Characterset=UTF16- You need to specify your application code page, if you application is ANSI (not unicode). It does not harm adding it, even if you application is Unicode. Add "IANAAPPCODEPAGE= " option to your odbc.ini. You need to choose right value for this option, matching your Chinese data, from "ODBC Application Code Page Values" table in Teradata ODBC User Guide ( : IANAAPPCODEPAGE=2026

You must sign in to leave a comment.