Archives of the TeradataForum

Message Posted: Wed, 13 Apr 2016 @ 19:56:05 GMT

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

Hi guys,

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).

Regards

David Clough
Data Architect (Database Design Specialist) Data Architecture

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