Hallo!!
Is it possible to set database (db2 v8) to be case insensitive??
--
Regards, Wojtas
Is it possible to set database (db2 v8) to be case insensitive??
--
Regards, Wojtas
-
-
Re: case insensitive ??
Take a look at this IBM article
http://tinyurl.com/23df3u
On May 21, 7:48 am, "news.onet. pl" <wkrugio...@poc zta.onet.plwrot e:Hallo!!
>
Is it possible to set database (db2 v8) to be case insensitive??
>
--
>
Regards, Wojtashttp://www.e-krug.com/
-
Re: case insensitive ??
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
news.onet.pl wrote:Hallo!!
>
Is it possible to set database (db2 v8) to be case insensitive??
>
>Comment
Comment