Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Jun 2005 @ 09:07:12 GMT


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


Subj:   Re: Does Teradata database 5.1 support internationalization
 
From:   Dennis Calkins

  We have made application in java with Teradata database 5.1. And now we we have to convert our application into unicode format so  


  So I have query that "Does Teradata database 5.1 support utf-8? " And how can we configure ? Which language supports by teradata?  


  Is there any sample application/web link with java which shows me fetching, inserting data into teradata database 5.1?  


Hi,

UTF-8 support was added in 4.1, with most of the client support coming TTU 7.0.

UTF16 support was added in 5.1 but only TTU 7.1 JDBC driver natively supports it. Other clients were added in Tw 8.0.

Java naturally does everything in utf16, so allowing the interface to Teradata in utf16 means that there is no required character translations in the server since internally the DBS server operates in UTF 16 mode as well.

With the Unicode session character set, you will get the data in Unicode (UTF16 for Windows, UTF8 for UNIX) thus your application becomes "universal".

JDBC 3.0 or above support UTF8 or UTF16 session character set.

Example of connection string:

     // Test Database connection
     String url_type4 = "jdbc:teradata://fsie2a/CHARSET=UTF8,TMODE=TERA";


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