RE: How can I create a case-insensitive database in oracle?
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.
Oracle Database Administrator
tel. +32 (0)3 451 23 82
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
Subject: How can I create a case-insensitive database in oracle?
I have read the following but I am looking for a way to create a case-insensitive database. Is it even possible?
Roger XuReceived on Mon Jul 20 2009 - 13:58:27 CDT