Re: How can I create a case-insensitive database in oracle?
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: wellmetus@xxxxxxxxx
- Date: Mon, 20 Jul 2009 18:57:30 +0200
Roger Xu wrote:
> 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
If you don't care about indexing, yes, certainly. Otherwise, just look
at how Oracle is doing it - create a table with all identifiers in mixed
case, and check what is stored in the data dictionary. When you have as
little hair left as I have, you appreciate this type of solution.
--
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
