Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Case insensitivity in Oracle 7.3 ???
I'd appreciate some advice on how one could go about
'faking' case-insensitive columns in a case-sensitive Oracle
7.3 database. We are going to migrate our database from a
case_insensitive SQL Anywhere platform, and we want to store
the actual case the user typed in, but have case
insensitivity for purposes of searching/matching.
I can think of one solution involving adding forced upper
case columns for indexing and searching of text fields, but
am hoping that there is a better way...
Regards, David. Received on Wed Dec 02 1998 - 00:55:53 CST