Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Case insensitivity in Oracle 7.3 ???
Hi
I've had pretty much the same problem, I've been using an Access front end with a SQL Server rear. The change to Oracle has been a major headache in terms of case sensitivity. I think your idea of using forced upper case indexing columns is good. However, I decided against that for compatibility reasons (the database front end has to be compatible with existing back ends). Instead I decided to UPPER (VB equivalent Ucase for all non-passthough queries) all criteria and tables used for reports (and mail merge letters). This still leaves me with a problem in with MS Access' Filter By Form facility (although Find seems to be case insensitive). I hope somebody else replies with a more universal solution.
David Pattinson wrote in message <3664E479.6EDE506E_at_addease.com.au>...
>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 - 10:08:37 CST