-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sascha,
Sascha Wehnert wrote: > 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. You should check the locale (and character set) being used by your JDBC connection. You may have to specify this as part of the URL. Also note that your database is probably going to do ORDER BY sorting differently than Java will if you use Collections.sort() to sort strings. > $LANG is set to de_DE.UTF-8 You know that this is German, not Polish, right? > and JAVA_OPTS includes “-Xms256m -Xmx512m -server -Dutil.language=de I've never heard of using "-Dutil.language=de" for anything before. IF you want to set the language of the JVM, you need to specify - -Duser.language=de and - -Duser.country=DE > 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. Changing the file encoding will only change how Java converts bytes into characters, and only when using the default language settings for the JVM. I also do not believe that $LANG has any bearing on the locale settings for the JVM. Your problem is likely to be the JDBC driver settings. Since you are not sorting in your Java code, then the database is to blame. Check your connection settings to ensure that you are using the proper locale for sorting, and I think you will end up with the sort order you want. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFv4tY9CaO5/Lv0PARArzxAKDD7Mjet4iqpNrxGjdv0Rak+an7HACglgoP mEchN+exwKOVW5X86GvYYPQ= =bsYL -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
