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
