Archives of the TeradataForum

Message Posted: Fri, 07 Nov 2003 @ 22:08:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This is something I ran into not too long ago. I don't know if your particular occurrence could be related to something in V2R5 or upgrading but I can say I've seen this error in earlier versions as well....The following may be useful to you in identifying the rows in your table that are the root cause of the problem. It is tedious detective work if your table has loads of columns but you can automate the process with a little work.

Step 1.
SELECT count(column_name) FROM table_name WHERE Translate_Chk(column_name using Latin_To_Unicode) <> 0 ;

Step 2. (perform if non-zero count value returned from Step 1. query)
SELECT column_name FROM table_name WHERE Translate_Chk(column_name using Latin_To_Unicode) <> 0 ;

	<Prev	Next>		<<First	<Prev	Next>	Last>>