Postgres Pro
Downloads
Home   >   mailing lists

Thread: Sorting by locale settings on Windows?

Sorting by locale settings on Windows?

From
Jirka Novak
Date:
Hi,

   I have PG 7.3.1 on W2K. I have DB with Latin2 encoding. All works
fine, but when I try ORDER BY clausule on text (varchar) columns, it is
sorted like with 'C' locale.
   I tried to change LC_XXX in postgresql.conf, but any other value than
'C' is rejected. On Linux it works fine with cs_CZ.
   Does anyone have some idea how to do it?

                        Yours,

                            Jirka Novak

Re: Sorting by locale settings on Windows?

From
Jason Tishler
Date:
Jirka,

On Mon, Jul 14, 2003 at 10:21:31AM +0200, Jirka Novak wrote:
>  I tried to change LC_XXX in postgresql.conf, but any other value than
>  'C' is rejected. On Linux it works fine with cs_CZ.
>
>  Does anyone have some idea how to do it?

Sorry, but Cygwin PostgreSQL only supports the "C" locale.  This is
because Cygwin itself does not fully support locales.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Sorting by locale settings on Windows?

From
Jirka Novak
Date:
>> I tried to change LC_XXX in postgresql.conf, but any other value than
>> 'C' is rejected. On Linux it works fine with cs_CZ.
>>
>> Does anyone have some idea how to do it?
>
> Sorry, but Cygwin PostgreSQL only supports the "C" locale.  This is
> because Cygwin itself does not fully support locales.

Bad for me... Do you have some information about native Windows port of
PG 7.4 - will it have full locale support?

                    Thanks,

                        Jirka Novak

Re: Sorting by locale settings on Windows?

From
Jason Tishler
Date:
Jirka,

On Mon, Jul 14, 2003 at 03:16:26PM +0200, Jirka Novak wrote:
> Do you have some information about native Windows port of PG 7.4 -
> will it have full locale support?

Sorry, I don't know.  I suggest trying on pgsql-hackers...

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Sorting by locale settings on Windows?

From
Jason Tishler
Date:
Jirka,

On Mon, Jul 14, 2003 at 03:16:26PM +0200, Jirka Novak wrote:
> >>I tried to change LC_XXX in postgresql.conf, but any other value
> >>than 'C' is rejected. On Linux it works fine with cs_CZ.
> >>
> >>Does anyone have some idea how to do it?
> >
> >Sorry, but Cygwin PostgreSQL only supports the "C" locale.  This is
> >because Cygwin itself does not fully support locales.
>
> Bad for me... Do you have some information about native Windows port
> of PG 7.4 - will it have full locale support?

Oh, I forgot to mention yesterday that you can always contribute locale
support to Cygwin while waiting for Win32 PostgreSQL.  BTW, Win32
support seems to scheduled for be 7.5 now...

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Sorting by locale settings on Windows?

From
Horak Daniel
Date:
>    I have PG 7.3.1 on W2K. I have DB with Latin2 encoding. All works
> fine, but when I try ORDER BY clausule on text (varchar)
> columns, it is
> sorted like with 'C' locale.
>    I tried to change LC_XXX in postgresql.conf, but any other
> value than
> 'C' is rejected. On Linux it works fine with cs_CZ.
>    Does anyone have some idea how to do it?

Cygwin (its C library called newlib) doesn't support other locale then
C.


            Dan