Case Sensitivity in DB2 on linux

[Suresh]

Hi All

I am new to Db2. This question may be very simple.
In SQL Server I can set database option as case sensitive or
insensitive. Because of this if I set option as case insensitive than
'a'='A' or 'suResH'='SURES H'
Is there any such option in DB2 8.1 For linux. Can I set proper
collating sequence to achieve this then how?

Thanks and regards
Suresh

[Serge Rielau]

Re: Case Sensitivity in DB2 on linux

Suresh wrote:[color=blue]
> Hi All
>
> I am new to Db2. This question may be very simple.
> In SQL Server I can set database option as case sensitive or
> insensitive. Because of this if I set option as case insensitive than
> 'a'='A' or 'suResH'='SURES H'
> Is there any such option in DB2 8.1 For linux. Can I set proper
> collating sequence to achieve this then how?[/color]
There is no database wide switch in DB2.
If you have certain columns you want to treat as case-insensitive you
can take a peek at this article:

http://www-128.ibm.com/developerworks/db2/library/techarticle/adamache/0430_adamache3.html

A more sophisticated version (culturally correct collation) can be found
here:

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602doole/

The user defined collation sequences facility provided by DB2 can be
used to change the order, but it does not allow for two different glyphs
to be equal.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab