Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Feb 2007 @ 16:53:10 GMT


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


Subj:   Accent Insensitive Matches
 
From:   mgalante

Is there a function or another method in Teradata SQL to remap accented characters to their unaccented counterparts when making comparisons between character strings?

I have read the documentation on collations, and it looks like using the multinational collation gets me pretty close since it uses the concept of equivalence classes in the sorting algorithms. In other words, {????} and their uppercase counterparts all belong to the E equivalence class, so they will be ordered properly when sorting.

The problem is that I cannot find a way to use this concept myself in Teradata SQL. When making searches, sometimes the accented characters get in the way, and usually it's not very practical to include every possible possibility to ensure there is a match.

So, even though R?sum? is not equal to Resume EquivalenceClass(R?sum?) is equal to EquivalenceClass(Resume) Making a match possible without specifying every possible spelling of "r?sum?".

In other words, I would need something similar to the NOT CASESPECIFIC option, but for accented characters.



     
  <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