Archives of the TeradataForum
Message Posted: Mon, 11 Jul 2005 @ 17:55:08 GMT
| Subj: || || Re: Teradata JDBC-Unicode Driver Problem |
| From: || || Takahashi, Takashi |
| ||I am using Teradata version 5.0 Demo version which is freely available in CD on
| ||We are able to insert Japanese data in to the Table whose columns are configured as Unicode using Teradata SQL Assist 6.1.|| |
Please make sure you are NOT using the ASCII session charset with SQLA6.1 and ODBC 3.3 (or eariler). If so, you basically store invalid Unicode
values into a Unicode column. You can char2hexint() to verify your Unicode data.
| ||But I am not able to insert the same data through my Java Program, using JDBC type -4 driver, with below Connection URL
> "pass123" (I have also tried with charset = "SJIS / KANJI").
A simple example of the connection string:
static Connection con;
String url = "jdbc:teradata://slugger/CHARSET=UTF8";
con = DriverManager.getConnection (url, "test", "test");
| ||I am using JDBC driver 188.8.131.52. Operating Systems is Windows Xp|| |
| ||When I insert data using this driver. It inserts "???".|| |
| ||Please advice if this is the correct version of JDBC driver for Multi Language support. or I have to change JDBC URL string.|| |
V2R5.1 and above support UTF16 session charset. V2R5.0 only supports UTF8 session.
With UTF8 session charset, Teradata JDBC driver converts Unicode strings from/to the session charset (UTF8). For non-preinstalled session
charsets (i.e. ASCII, EBCDIC, UTF8 and UTF16) such as KANJISJIS_0S for Japanese, you need to install/activate the session character set on
Teradata. Make sure you have installed required session charsets by "Select CharSetName,CharSetId,InstallFlag from dbc.CharTranslations order by