Re: using multiple sort orders in one database

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