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

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: niall.litchfield@xxxxxxxxx
  • 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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2009