By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

Case Sensitivity in DB2 on linux

P: n/a
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?

Thanks and regards
Suresh

Mar 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Mar 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.