|
|
Archives of the TeradataForum
Message Posted: Wed, 14 Feb 2007 @ 12:43:29 GMT
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.
Regards,
Victor
| |