Thanks, I have not written the like tests yet, and am looking for
examples like the following where the result under the default
system is different under collation vs default that can be added
to the junit tests, but have to admit I don't know much about
languages other than english. I think I need unicode escape for non-ascii
characters so that I can get them into a java program using my
terminal.
I currently test english, polish, and norway but only have some
simple ordering examples so far, but the test is set up to
easily add other territories if anyone is interested.
Knut Anders Hatlen wrote:
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! :)
