Mamta Satoor <[EMAIL PROTECTED]> 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
