467,923 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

Case Sensitivity in DB2 on linux

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
  • viewed: 1407
Share:
1 Reply
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.

Similar topics

32 posts views Thread by Elliot Temple | last post: by
761 posts views Thread by Neo-LISPer | last post: by
6 posts views Thread by bigbob | last post: by
14 posts views Thread by Christian Sell | last post: by
15 posts views Thread by gregory_may | last post: by
2 posts views Thread by sweetpotatop | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.