Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
> hsasaki@best.com (Harold Sasaki) writes:
> Can someone help me out on how to do a case-insensitive SELECT on a string?
> Using version 7.1. Thanks in advance.
>
>>>>
We have added an extra column to the table to do this. Maintenance of that extra
column is however a significant problem. You may be able to write a triggered
stored procedure to maintain it. Otherwise you will have to include its
maintenance in every program that updates the table. We have had to do this as
we require more than simply case insensitivity (we do phonetic search).
For the Informix wish-list:
A more powerfull SPL that could do full character handling.
Implementation of the NewEra language (as far as possible) would be the ideal.
Of course we also regard it as self evident that it should have been possible to
call C/C++ functions from the SPL (realizing the dangers!). Obviously these
would have had to be compiled into a DLL so no linking of new "runners" would be
neccessary.
Any comments appreciated. Particularly from Informix.
Nils.Myklebust@ccmail.telemax.no
NM-data, Dalsbergstien 7, N-0170 Oslo, Norway
My opinions are those of my company
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.