Archives of the TeradataForum
Message Posted: Fri, 09 Feb 2007 @ 21:55:15 GMT
Subj: | | Re: Accent Insensitive Matches |
|
From: | | Victor Sokovin |
| Hi Etienne. Thank you for providing the solution involving the installation of an Oracle UDF. I am sure that it would work. However, I am
an end-user and cannot make decisions regarding new installations. I can suggest this to my support group but am not sure of the outcome. At
best, it could be a lengthy process. | |
Your situation is not unusual but the phrase "I am an end-user and cannot make decisions regarding new installations." strikes me as too
pessimistic. The database is for end-users so they should decide what they want to do with it, no?
Having said that, the UDF threshold might be too high for an ad hoc request of one user. Compiling C code was not something end-users used to
do on a regular basis over the last 10-15 years.
| Are there any other solutions not involving admin changes to the Teradata server? | |
Yes. But before I describe them I'd like to mention that you can customize collation rules and define your own collation. Once you choose it
for your session you can effortlessly compare strings according to your rules. I'd say it is the most natural solution in this situation but it
does require some admin effort. Perhaps more effort than with UDF as customized collations are exotic.
Non-admin method would be to use the brute force and convert your data character-by-character and store it somewhere for further analysis.
SUBSTRING and CASE should do the business if you give them enough time. Not elegant but doable.
Anyway, good luck with this, and keep us posted.
Regards,
Victor
|