RE: Case Insensitive Searches

Posted in 1998

Leffler, Jonathan — Fri, 27 Mar 1998 12:15:11 -0800 — source: Informix-list mailing list archive (1991-1998)

You upgrade it to 7.30 and then use the built-in UPPER or LOWER functions. Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> ---------- From: John S. Michael[SMTP:john.michael@flyingj.com] Sent: Friday, March 27, 1998 9:26 AM To: informix-list@iiug.org Subject: Case Insensitive Searches We're trying to figure out how to make our Informix 7.22 database case insensitive when it comes to searching. I've read in the manual about the Collation Order either using the Code-Set Order or Localized Order, and if the Localized Order isn't specified, then the database defaults to Code-Set Order. How do we set up our database to do case insensitive searches? Thanks. John S. Michael Flying J Inc.