Re: illegal sort order

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andrus <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: illegal sort order
Date: 2005-07-12 18:29:27
Message-ID: 20050712182927.GA17782@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 12, 2005 at 20:45:37 +0300,
Andrus <eetasoft(at)online(dot)ee> wrote:
>
> How to force the correct sort order or at least move accented characters
> ÕÄÖÜ to end of sorted list ?

Sort order depends on the locale used in initdb. If you want data sorted
by the codes used to represent the data, then you might want to initdb
with a locale of "C". Doing an initdb will require a dump and reload.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Patnude 2005-07-12 18:29:58 Re: Checkpoints are occurring too frequently...
Previous Message Mohan, Ross 2005-07-12 18:24:52 Re: [PERFORM] Projecting currentdb to more users