Archives of the TeradataForum

Message Posted: Mon, 03 Oct 2005 @ 18:35:23 GMT

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

For those character set problems, it will be helpful for others to include information about:

1) Server character set in your Teradata tables (LATIN, UNICODE, etc.)

2) Session character set in the client interface

Assuming you created a table with the default character set, which is LATIN on the standard system, it should work for French as French is part of LATIN1 language group.

Assuming you don't set the session character set in the JDBC connection string, then it will be ASCII by default (by DBS). The ASCII in Java code page means by US ASCII, thus your non-7-bit ASCII characters were not converted to Unicode characters in JDBC driver, as JDBC driver is trying to convert Java Unicode strings into the session character set.

Solution:

Try to use UTF8 or UTF16 session character set in the connection string.

e.g.

     static Connection con;
     String url = "jdbc:teradata://slugger/CHARSET=UTF8";

Tak Takahashi
Teradata San Diego

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