Archives of the TeradataForum
Message Posted: Wed, 15 Jun 2005 @ 09:07:12 GMT
| 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";
| 
