Archives of the TeradataForum
Message Posted: Tue, 06 Feb 2007 @ 16:53:10 GMT
| 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.
| 
