RE: How can I create a case-insensitive database in oracle?

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Mon, 20 Jul 2009 20:58:27 +0200
Message-ID: <4814386347E41145AAE79139EAA398980931AC0C2D_at_ws03-exch07.iconos.be>

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_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu [wellmetus_at_gmail.com] Sent: 20 July 2009 18:49
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 20 2009 - 13:58:27 CDT