|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/3/2009 8:16:08 PM
Posts: 3,
Visits: 9
|
|
Hi ,
I'm using ODBC driver 3.04.00.00 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 configuration
Driver=tdata.so
Description=NCR 3600 running Teradata V1R5.2
DBCName=TDDEV
LastUser=
Username=
Password=
Database=
DefaultDatabase=
Is there anything missing in above file?
Any help/thoughts will be appreciated.
Thanks
Siva.
Siva
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
|
Is your username set up with a default character set of Unicode?
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/10/2009 4:46:45 PM
Posts: 26,
Visits: 110
|
|
- 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 (http://www.info.teradata.com/eDownload.cfm?itemid=082330030)
Ex : IANAAPPCODEPAGE=2026
|
|
|
|