Re: How can I create a case-insensitive database in oracle?
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 20 Jul 2009 18:57:30 +0200
Message-ID: <4A64A1FA.3090001_at_roughsea.com>
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
Date: Mon, 20 Jul 2009 18:57:30 +0200
Message-ID: <4A64A1FA.3090001_at_roughsea.com>
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> -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 20 2009 - 11:57:30 CDT