InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 01:59:17 GMT20http://www.teradata.com/teradataforum/Topic10961-11-1.aspxWhen using JDBC to retrieve characters from a char column in UTF8 charset session, we get a character string of double the size of the column length. Does anyone know why and how to workaound it?For example: 1. connect to the database in UTF8 sessionjdbc:teradata://td/CHARSET=UTF82. create table and insert dataCREATE TABLE employee (empName CHAR(10));INSERT INTO empolyee values('a');3. SELECT empName from employeeThe length of empName is 20. (Wrong!)4. connect to the database in default charset sessionjdbc:teradata://td5. SELECT empName from employeeThe length of empName is 10. (Correct!)I'm using JDBC Driver 12.0.0.1 and the database is V2R6.Mon, 17 Mar 2008 11:49:06 GMTyulian