Hi, found the solution: The PostgreSQL database has to do the sorting correctly. Therefore the following steps are required:
As database admin (User ID postgres) initialize the database with the locale set correctly and appropriate encoding. In my case this was: export LC_ALL=de_DE initdb -E LATIN1 Of course you will have to delete all your data before this step so you would want to pg_dump your database content first, and then reimport it as described in the manpage of pg_dump. When you now create a new database in admin.pl it will use the default LATIN1 for encoding and the LC_ALL used during initdb. Best regards Rainer > -----Original Message----- > From: Stumbaum, Rainer [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 5:16 PM > To: [EMAIL PROTECTED] > Subject: [SLG] FW: [SL] Sorting with german Umlauts > > > Vielleicht kann ja hier jemand helfen??? In dieser > mailing-liste sollte es ja mehrere Leidensgenossen geben... > > -----Original Message----- > From: Stumbaum, Rainer [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 4:13 PM > To: [EMAIL PROTECTED] > Subject: RE: [SL] Sorting with german Umlauts > > > Strange, if I look into SL/CT.pl, search, the sorting is done > by the database (ORDER BY), not by perl. The locale of apache > as well as the postgresql userid are set to german.... . > > Cheers > Rainer > > > -----Original Message----- > > From: Jonas Smedegaard [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 15, 2002 3:17 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [SL] Sorting with german Umlauts > > > > > > On Mon, 15 Jul 2002, Stumbaum, Rainer wrote: > > > > > The �, �, and � are at the bottom of my lists. No major > problem with > > > "M�ller", but looking for "�zcalan" after a Z-blabla-customer is > > > annoying.... > > > > > > Anybody had this problem before??? How to get around that??? > > > > Setting your locale should do the trick. > > > > Maybe this helps: http://www.perldoc.com/perl5.6.1/lib/locale.html > > > > - Jonas > > > > -- > > Jonas Smedegaard (+45 40843136) http://dr.jones.dk/~jonas/ > > Spiff ApS (= IT-guide dr. Jones ApS) http://dr.jones.dk/ > > Debian GNU/Linux developer > http://people.debian.org/~js/ > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
