Archives of the TeradataForum
Message Posted: Wed, 13 Apr 2016 @ 19:56:05 GMT
I'm tasked with matching people's names between two systems, one of which seems to hold it with Unicode characters in place and the other without those characters.
For example, one system would hold Maonien? (notice the unicode acute accent character over the last 'e' ?) and another system would hold Maoniene (i.e. no accent on the last 'e')
Not surprisingly, when I match them in SQL they do not match, even though it implicitly translates the Latin Character Set to Unicode.
So, my question is, is there a way of comparing the two names and getting a match, by effectively ignoring special acute characters, ablauts, etc?
I know I can Translate To Latin WITH ERROR but that then doesn't seem to match the Unicode name (not that I expected it to).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|