Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 14 Feb 2007 @ 10:21:06 GMT


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


Subj:   Re: Accent Insensitive Matches
 
From:   Mario Galante

  No, that would not take anything "extremely complex" (esthetically non-pleasing at the most) and the queries would not be much slower than the ones with UDF. You surely do not expect a few lines of C in the UDF (and that's what they are) to compete with the internal conversion routines already present in the database, don't you? And you can be smart and selective and only convert when there is something to convert, etc.  


Victor, I was kind of skeptical, but you know what? After a few preliminary tests using a limited number of characters to replace, the performance is really not that bad. Of course, as you mention, the resulting SQL code is horrendously lengthy, and I actually wrote a VB program to generate it.

I will also explore the customized collation alternative. I called my support group today and was told that it may just be possible for end- users who request the option to create their own collations. After that, I'm going to take a deep breath and dive! As you mentioned earlier, customized collations seem to be a pretty advanced feature. I may ask further questions! :)

Thank you once again for all your help!



     
  <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: 28 Jun 2020