Archives of the TeradataForum
Message Posted: Wed, 12 Sep 2007 @ 19:44:38 GMT
| Subj: | | Re: To check for Non ASCII in the data |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, September 12, 2007 13:42 -->
| | Is there a way to check for NON ASCII characters in data in a column.? | |
A UDF udf_checkascii() will find the # of non 7-bit ASCII characters and report it to you.
Example:
select udf_checkascii(_LATIN'414243818283414243'XC);
return value: 3
The UDFs for MP-RAS are included in Unicode tool kit that can be downloaded below.
www.teradata.com/t/page/147986/index.html
| 
