Hi, I did some further inquiries. I logged on to the database with psql and did following query:
select id, name from customer order by name; The sorting is done wrong already in the DB. >From my point of view the sorting has to be done according to the user setting >"Language" in the SQL-ledger user-settings (the german wants a german sorting and the >dansk wants a danish sorting...) even if they are working in the same system together >(multilanguage company...). No idea, how to continue from here... Rainer > -----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
