Hi folks,



we encountered a problem (for us) in how Tomcat 5.5.20 returns requested data.

In our case we selected user data ordered by family name containing special polish

characters from an Oracle database. As soon as the familiy name starts with

a special character, the name gets listed at the bottom of the output and not in

alphabetical order.



If I run the same query on the database the values returned look pretty good. So I

assume my Tomcat instance was configured with the wrong settings. $LANG is set

to de_DE.UTF-8 and JAVA_OPTS includes “-Xms256m -Xmx512m -server -Dutil.language=de

-Djava.library.path=/opt/apr127/lib -Dfile.encoding=UTF-8”. All settings are placed in

catalina.sh, of course with an export command in front of them ;-)



Even if I change $LANG to pl_PL.UTF-8 or use –Dfile.encoding=UTF-8 it doesn’t change

anything about the sort order.



Am I missing here some JAVA options? Has anyone of you perhaps come across

a similar problem and could give me some pointer in the right direction?



regards,



Sascha