Case Insensitive Searches

Posted in 1998

John S. Michael — Fri, 27 Mar 1998 10:26:12 -0700 — source: Informix-list mailing list archive (1991-1998)

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.