junit - Testing DB2 order in java -
i'm working db2 , when use query order such as
select pers.first_name person_name pers order pers.first_name;
i got result
amanda bannersbroker banbrcustomer30 bob bruce chack christoper chuck customer customer1 danielle eileen first first frida grady heath jack john jude magdeline miipecustomer01 miipecustomer02 olive paul pay recipient1 require rina robin sean testpartner1 testpartner2 theodore tom tomy tony tory user zane and collations settings database is:
database territory = database code page = 1208 database code set = utf-8 database country/region code = 1 database collating sequence = system_1252 alternate collating sequence (alt_collate) = number compatibility = off varchar2 compatibility = off date compatibility = off database page size = 4096 i suppose db2 uses specific algorithms make ordering.
the question how test such ordering using java? there libraries can such string comparisons?
ps: tried collator jdk 6 , icu4j different settings , didn't help.
have looked @ set option srtseq (and possibly langid) in sql reference edition of db2? (luw, z/os, or ibm i)
Comments
Post a Comment