case insensitive select

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Odd Bjørn Andersen - 24 Jan 2006 10:34 GMT

Is there a way to achieve that a select against a database will be case
insensitive?

Meaning that 'select ' from tab1 where col1 = 'abc'' will return the same
result as 'select ' from tab1 where col1 = 'ABC'' . I know the functions
UCASE and LCASE (and TRANSLATE), but this is not what I'm after now. I am
looking for some kind of parameter (on the client or the database server)
that will achieve this.

I'm told that this is possible on both Oracle and Sql Server. But what
about db2?

Regards
Odd B Andersen
ErgoGroup AS

Reply to this Message

Serge Rielau - 24 Jan 2006 11:56 GMT

> Is there a way to achieve that a select against a database will be case
> insensitive?
[quoted text clipped - 7 lines]
> I'm told that this is possible on both Oracle and Sql Server. But what
> about db2?

There is no database wide parameter. You can handle case insensitivity
per column using GENERATED columns.
If you want teh whoel database to be case insensitive, why not just
normalize the data to all upper or lower caps?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message