Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.  

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://","tdatauser",
          > "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 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 2;".


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023