RE: How can I create a case-insensitive database in oracle?
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "wellmetus@xxxxxxxxx" <wellmetus@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 20 Jul 2009 20:58:27 +0200
You could set the nls_comp parameter to "linguistic".
This should also work when using the like operator.
Of course, you should test very carefully for possible side affects.
regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge@xxxxxxxxx
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
Of Roger Xu [wellmetus@xxxxxxxxx]
Sent: 20 July 2009 18:49
To: oracle-l@xxxxxxxxxxxxx
Subject: How can I create a case-insensitive database in oracle?
Hi List,
I have read the following but I am looking for a way to create a
case-insensitive database. Is it even possible?
http://askanantha.blogspot.com/2007/07/making-oracle-case-insensitive.html
Thanks,
Roger Xu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
