Unrecognized ICU conversion error when selecting special characters

Database
Highlighted

Unrecognized ICU conversion error when selecting special characters

Hi folks, I am new to Teradata and have been banging my head into the following problem for quite a while without any progress, so I am writing to seek a bit help from this forum Smiley Happy

I was doing a very simple select from a Teradata table, here is the query.

 

SELECT
    country,
    province,
    city,
    address_line_1,
    address_line_2,
    address_line_3
FROM prod_schema.address_table
WHERE 
    country = 'DE'
    AND TRANSLATE_CHK(address_line_1 USING UNICODE_TO_LATIN) = 0
    AND TRANSLATE_CHK(address_line_2 USING UNICODE_TO_LATIN) = 0
    AND TRANSLATE_CHK(address_line_3 USING UNICODE_TO_LATIN) = 0;

While executing the select I encountered the following error.

 

[HY000] [Teradata][Support] (50310) Unrecognized ICU conversion error.') 

My connection is tmode=ANSI,charset=UNICODE.

The idea is to select all address records in Germany. I did some check and it seems there are some sepcial characters in some of the records, such as é, ø, §, etc. I wonder whether I am writing the SQL in the correct way, and how I can fix the error while reading the data, and what changes I need to get the results back normally?

 

Your help is greatly appreciated. Thank you in advance!

 

 

 


Accepted Solutions
Teradata Employee

Re: Unrecognized ICU conversion error when selecting special characters

CHARSET=UNICODE is not a supported option for Teradata JDBC. Try CHARSET=UTF8.

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: Unrecognized ICU conversion error when selecting special characters

CHARSET=UNICODE is not a supported option for Teradata JDBC. Try CHARSET=UTF8.