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

Popular posts from this blog

matlab - Deleting rows with specific rules -

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -