Suresh wrote:
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'='SURESH'
Is there any such option in DB2 8.1 For linux. Can I set proper
collating sequence to achieve this then how?
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/developerwork...adamache3.html
A more sophisticated version (culturally correct collation) can be found
here:
http://www-128.ibm.com/developerwork.../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