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??
"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?