Re: Case Insensitivity

Andrew Hamm wrote: > Serge Rielau wrote: > >> There is a developerWorks article exploiting ICU sort keys for DB2 via >> UDRs. I think it should be easy for anyone who has written a C UDR in >> the past to adopt it to IDS: >> > http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602doole/ > >> What this gives you is not only case-insensitive search but also accent >> insensitive etc, etc... > > As virtual inventors of Unicode, the ICU etc, I'm really surprised that IBM > doesn't have comprehensive locale support in DB2. That's really quite > surprising. You are preaching to the choir. DB2 has been dragging it's feet, but we are promising to better ourselves. >> Combined with IDS function indexes the solution should perform nicely. >> (Maybe Jacques can be convinced to translate the article to IDS speak..) > > The article does give new interesting information, and hopefully some C code > that I can fiddle with to gain hands-on experience with the whole subject. > Wish me luck. Ah, come on, luck has nothing to do with it. You just need to rely on your superior skills :-) Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab WAIUG Conference http://www.iiug.org/waiug/present/Forum2006/Forum2006.html