Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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).


Regards

David Clough
Data Architect (Database Design Specialist) Data Architecture



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