String Search in Oracle Database
Date: 1999/02/03
Message-ID: <36B82E7A.B0640BC_at_starnet.gov.sg>#1/1
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.