Hi Алексей,
I don't know the specifics of the MySQL collations. Derby lets you
select any collation/strength combination which is supplied with the
JVM--from your connection URL it looks like you understand how to select
a collation/strength combination. If the JVM doesn't supply the
collation you need, you can always write your own. For details on how to
do this, please take a look at
http://blogs.oracle.com/kah/entry/user_defined_collation_in_apache
Hope this helps,
-Rick
On 11/25/11 12:43 AM, Алексей Газукин wrote:
Good day!
I have a question?
I use adatabaseDerby andran intothis problem.I cannormallysort the
valuesof the database.In the databaseI'm usingthe Ukrainian language.
*My**query**looks like this "select * from TSOU.PUIPLE WHERE pgroup =5
and pyear=2011 order by SURNAME"*
after the queryI geta tablein the form (seeattachment1.png)
solooks correct(seeattachment2.png)
In MySQLthe queryis solved as follows "*/select * from TSOU.PUIPLE
WHERE pgroup =4 and pyear=2011 order by SURNAME /**/order by COLLATE
utf8_unicode_ci"/*
I have tried tosolveit this way,butresults have not been
*/"jdbc:derby:E:/myproject/jtsou/DB/TSOU;create=true;collation=TERRITORY_BASED:PRIMARY
"/*
Howcan I makethis queryin Derby?
During theearliergrateful
--
Алексей Газукин
