Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Name matching issue
From:   David Clough

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


David Clough
Data Architect (Database Design Specialist) Data Architecture

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020