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

What's about an insert/update trigger which converts everything to upper or lower case?

Am 20.07.2009 um 19:35 schrieb Niall Litchfield:

> Assuming that you mean you want to make all string data case
> insensitive and that the requirement has come from developers who
> don't want to check their inputs for case errors (though I bet they
> want to say business logic is an application function) then a check
> constraint on each column that the inserted/updated value is equal to
> its uppercase representation is a start. Then they'll have to either
> check for the constraint failing or start discussions with you about
> database input validation aka constraints.
>
> On 7/20/09, Roger Xu <wellmetus_at_gmail.com> 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
>>
>
> --
> Sent from Google Mail for mobile | mobile.google.com
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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




application/pkcs7-signature attachment: smime.p7s