Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Feb 2007 @ 12:43:29 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Accent Insensitive Matches
From:   Victor Sokovin

  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.  

Mario, thank you for the confirmation. That matches my expectation. String manipulations are important in all databases. What do we do with the databases at the end of day? Some mathematics and some string manipulation. So, it would be logical to assume that Teradata did not waste 25 years of their history and already optimized these two main areas to the level on which it is hard to compete with them having only a new UDF with 10 lines of code in 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! :)  

Sure, this topic is more fun to discuss than UDF, so I for one don't mind if you continue posting on this relatively unknown area. Thanks again.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023