Archives of the TeradataForum
Message Posted: Thu, 11 Sep 2003 @ 10:59:12 GMT
I am trying to use the soundex() function to code surnames from two different sources for matching. When I submit
select sname , soundex(sname) as sdx from t ;
Through SQL Assistant, I get the error
5583: Invalid Input: only Latin letters allowed.
The table t is defined as
CREATE SET TABLE db.t ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL ( id INTEGER NOT NULL ... , SNAME VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC ... ) UNIQUE PRIMARY INDEX ( id );
So I was surprised that there where 'Non-Latin' Characters in the field.
My questions are these:
1) How do I detect these 'Non-Latin' Characters and then
2) How do I remove them from the string or better yet,
3) how do I get the best use of soundex()
Any Comments / suggestions gladly accepted.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|