case insensitive ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.onet.pl - 21 May 2007 15:48 GMT

Hallo!!

Is it possible to set database (db2 v8) to be case insensitive??

Signature

Regards, Wojtas
http://www.e-krug.com/

Reply to this Message

Visu - 21 May 2007 21:12 GMT

Take a look at this IBM article

http://tinyurl.com/23df3u

http://www-128.ibm.com/developerworks/db2/library/techarticle/0203adamache/0203a
damache.html

> Hallo!!
>
[quoted text clipped - 3 lines]
>
> Regards, Wojtashttp://www.e-krug.com/

Reply to this Message

aj - 21 May 2007 21:52 GMT

Speaking for DB2 LUW (Linux, Unix, Windows), not that I have ever seen.

Looks like upper() (or lower()) is your new best friend..

Hint: use a generated column for the uppercase, and index off that.
CREATE TABLE FOO
(c1 VARCHAR(255), c1_upper GENERATED ALWAYS AS (UPPER(c1))) ;
CREATE INDEX idx ON FOO(c1_upper);

hth
aj

> Hallo!!
>
> Is it possible to set database (db2 v8) to be case insensitive??

Reply to this Message