Re: How can I create a case-insensitive database in oracle?
Date: Mon, 20 Jul 2009 20:51:06 +0200
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?
>> Roger Xu
> Sent from Google Mail for mobile | mobile.google.com
> Niall Litchfield
> Oracle DBA
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 20 2009 - 13:51:06 CDT
- application/pkcs7-signature attachment: smime.p7s