Archives of the TeradataForum
Message Posted: Fri, 28 Feb 2003 @ 01:13:58 GMT
I've seen a number of usefull tips sent to you already and I'd like to add one more.
For a more generic check, to determine if you have inappropriate data in a column, is to use the TRANSLATE_CHK function. This will return a non-zero result if it cannot translate data into a specified character set. Further information can be found in the "Teradata SQL Reference Volume 5: Functions and Operators" manual.
Your query would look something like this....
select * from tablename where TRANSLATE_CHK( string_column USING Unicode_TO_Latin) <> 0;
This would return all records where the "string_column" contained data which could not be translated to a "Latin" character set.
Different comparisons are described under the "TRANSLATE" function in the above manual.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|