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
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!
Solved! Go to Solution.