Re: Case insensitivity
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 17:24:52 +0800
hi,Skursk=FD_Michal
It is no way. oracle has no option for that .
Best regards
yahoo id: feng_chunpei
A new dba from china
---- from the mail-----
>Hello,
>I have an application in which I cannot change the code. There=
is a =3D
>search function in the application on char or varchar2 table=
column. =3D
>Search function is case sensitive as the author didn't use lower=
or =3D
>upper functions in select statement.
>My question is:
>Does exist any trick, how to make this search function case=
insensitive =3D
>only through database or user parameters/options? - I cannot=
imagine =3D
>that, but ....=3D20
>Oracle 8.1.7, Win2000
>The reason why I am asking this question too is, that I was=
told, that =3D
>MS SQL has such an option.
>Thanks=3D20
>Michal
>----------------------------------------------------------------=
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=
>To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
