Could this not be done as part of the initialization of the SL dataset? I run different language versions of my machine and setting the locale globally for the postgresql user is not adequate.
Kind regards keld On Thu, Jul 18, 2002 at 10:14:55AM +0200, Stumbaum, Rainer wrote: > 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]/ ------------------------------------------------------- This sf.net email is sponsored by: Dice - The leading online job board for high-tech professionals. Search and apply for tech jobs today! http://seeker.dice.com/seeker.epl?rel_code=31 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
