Multilingual application, ORDER BY w/ different locales?

From: Palle Girgensohn <girgen(at)partitur(dot)se>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Multilingual application, ORDER BY w/ different locales?
Date: 2001-11-17 16:50:38
Message-ID: 68010000.1006015838@palle.girgensohn.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

We are using postgres as RDBMS in an web application that is translated to
about a dozen different languages. Some users get puzzled about the sorting
order in lists, since we have to choose only one locale for all ORDER BY
queries. I am dreaming of a SET LC_COLLATE or simliar command that will
only affect my session, not all other users.

I know this is not implemented in postgres. How impossible is it to add
this feature, and what implications would pg suffer? All discussions
regarding locale problems in postgres are about LIKE indexing. For us,
collating is more important. Can we help?

/Palle

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-11-17 17:33:02 OCTET_LENGTH is wrong
Previous Message Justin Clift 2001-11-17 15:26:48 Re: Super Optimizing Postgres