Re: How can I create a case-insensitive database in oracle?
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?
> 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