Archives of the TeradataForum

Message Posted: Mon, 11 Jul 2005 @ 17:55:08 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

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 www.teradata.com .

We are able to insert Japanese data in to the Table whose columns are configured as Unicode using Teradata SQL Assist 6.1.

[TT]
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 string:

          > jdbc:teradata://10.82.12.4/Test_JP/CHARSET=UTF16","tdatauser",
          > "pass123" (I have also tried with charset = "SJIS / KANJI").

[TT]
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 3.1.0.10. 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.

[TT]
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 2;".

TakT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference