Обсуждение: using multiple sort orders in one database

Поиск
Список
Период
Сортировка

using multiple sort orders in one database

От
"prime factory: Michael Jürgens"
Дата:
Hi,

I have to a multilanguage website with postgres 7.3 as backend.
This website uses english, german, and turkey as languages, so I have to
use different sort orders in my queries.

So far I understood the docs, I have to set the correct language
settings when executing initdb.

But how can I support 3 different languages?

Best regards,

Michael

Re: using multiple sort orders in one database

От
Antti Haapala
Дата:
On Thu, 20 Feb 2003, prime factory: Michael Jürgens wrote:

> I have to a multilanguage website with postgres 7.3 as backend.
> This website uses english, german, and turkey as languages, so I have to
> use different sort orders in my queries.
>
> So far I understood the docs, I have to set the correct language
> settings when executing initdb.
>
> But how can I support 3 different languages?

Someone asked that a day or two ago. The problem is that support for
multiple locales hasn't been done yet. Until that the simplest way is
probably to sort in your client app.

--
Antti Haapala

Re: using multiple sort orders in one database

От
Bruce Momjian
Дата:
Antti Haapala wrote:
>
> On Thu, 20 Feb 2003, prime factory: Michael J?rgens wrote:
>
> > I have to a multilanguage website with postgres 7.3 as backend.
> > This website uses english, german, and turkey as languages, so I have to
> > use different sort orders in my queries.
> >
> > So far I understood the docs, I have to set the correct language
> > settings when executing initdb.
> >
> > But how can I support 3 different languages?
>
> Someone asked that a day or two ago. The problem is that support for
> multiple locales hasn't been done yet. Until that the simplest way is
> probably to sort in your client app.

You can have separate languages for each database, but not in the same
database.  You are probably best using unicode and having the client
deal with it --- at least that is my guess.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073