Hallo,

cause my other thread (2005-09-19) seems to be damaged
here again my question:

we are running an Informix Dynamic Server and have a problem with
converting special characters (e.g. German Umlauts äöüÄÖÜ) to
upper or lower case with the Informix functions upper() or lower()
cause there is no converting of them.
This is a problem when trying to do a case insensitive search in a string column.
Is it possible to solve the problem with configuring the Locals
or anything else ?

Thanks for any help.
ifx

Hallo again,

I don't think, that nobody else has this problem!?
Any comment will help ("we don't have this problem, but I don't know why" or "I had the same problem and didn't found a solution, too").

It cannot be a good solution to create an extra column (with manually converted strings) for each column doing a case insensitive search on, right?

And a matching search with each letter in both cases in regex (e.g. "[Mm][Ää][Rr][Zz]" when searching for case insensitive "März") is too slow and so a bad solution, too.

Thanks for any help or comment.
ifx