Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 09 Feb 2007 @ 21:55:15 GMT

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

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.



  <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: 15 Jun 2023