Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: Upper/Lower of Special Characters


    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.

  2. #2
    Join Date
    Feb 2005
    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 "Mrz") is too slow and so a bad solution, too.

    Thanks for any help or comment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts