Re: String Search in Oracle Database

Lim Wee Shoong wrote:

> Hi,
>
> I understand that Oracle stores string (varchar2) exactly as the way the
> user enters into the database, and it is case-sensitive, correct me if
> I'm wrong. So if we are to select a certain string from the database, we
> have to enter it exactly as the way it was entered for storing, for
> example, if the a string is stored in the database as "AbcDefGhi" when
> selecting that string, we will have to state exactly "AbcDefGhi", or the
> select will be a failure. Is this true?
>
> And is there any way to overcome this constraint so that the select of
> the string will be not be case-sensitive? As for my project, different
> users may have different style of entering information into the system.
> So for the person who is querying the database, it is impossible to know
> how the information was entered and stored in the database.
>
> We thought of converting everything into upper or lower case before
> storing, however, as the language prowess of my users are rather
> limited, it will be difficult for them to read and understand a sentence
> that is either in full upper or lower case.
>
> Thanks.

I can't see why not you convert the column to upper case for comparison in a query and
then display the original column when fetching out the query result to the users screen.

John K. Received on Mon Feb 08 1999 - 00:00:00 CET