Case insensitivity
- From: Skurský Michal <Michal.Skursky@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 11:17:08 +0200
Hello,
I have an application in which I cannot change the code. There is a =
search function in the application on char or varchar2 table column. =
Search function is case sensitive as the author didn't use lower or =
upper functions in select statement.
My question is:
Does exist any trick, how to make this search function case insensitive =
only through database or user parameters/options? - I cannot imagine =
that, but ....=20
Oracle 8.1.7, Win2000
The reason why I am asking this question too is, that I was told, that =
MS SQL has such an option.
Thanks=20
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
-----------------------------------------------------------------
Other related posts:
