db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Another collation question - Derby-1478 and Derby-2377
Date Wed, 16 May 2007 21:30:20 GMT
Mamta Satoor <msatoor@gmail.com> writes:

> Knut, only LIKE comparison can be done on LONG VARCHAR and CLOB data types.

Thanks, Mamta. And LIKE comparisons are indeed affected by collation:

ij> connect 'jdbc:derby:db;create=true;collation=TERRITORY_BASED;territory=no_NO';
ij> create table clobs (c clob(10));
0 rows inserted/updated/deleted
ij> insert into clobs values 'Waagan';
1 row inserted/updated/deleted
ij> select * from clobs where c like 'W_gan';
C         
----------
Waagan    

1 row selected

Cool! :)

-- 
Knut Anders

Mime
View raw message