Getting junk values from Teradata thru JDBC driver

Database

Getting junk values from Teradata thru JDBC driver

While retrieving the data from Teradata using Teradata JDBC driver 4.0, we are getting junk values if the data has special characters like French ­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­Apostrophe­ and Euro currency symbol. We observed that result set itself having the junk value which is before retrieving. We tried with UTF-8 and unicode strings but couldn't resolve. It's a java application and we are setting character set on JDBC driver profile in WAS server. Any thoughts??

1 REPLY
Teradata Employee

Re: Getting junk values from Teradata thru JDBC driver

"4.0" is not a valid version number of the Teradata JDBC Driver.

Only Unicode table columns are supported for storing non-Latin characters; however, some customers use the unsupported approach of storing non-Latin characters in a Latin column.

Are the special characters stored in a Latin column or a Unicode column?

  • If the special characters are stored in a Latin column, then please be aware that resolving that issue is a large and complex operation -- too large to cover in this forum thread. Please open a customer service incident and engage help for migrating your non-Latin character data into Unicode columns.
  • However, if the special characters are stored in a Unicode column, then can retrieve them with the Teradata JDBC Driver by specifying either the CHARSET=UTF8 or the CHARSET=UTF16 connection parameter. Here is the link to the Teradata JDBC Driver User Guide information about the CHARSET connection parameter:

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_CHAR...