| Lists: | pgsql-cygwin |
|---|
| From: | Jirka Novak <j(dot)novak(at)netsystem(dot)cz> |
|---|---|
| To: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Sorting by locale settings on Windows? |
| Date: | 2003-07-14 08:21:31 |
| Message-ID: | 3F12680B.8040706@netsystem.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
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
| From: | Jason Tishler <jason(at)tishler(dot)net> |
|---|---|
| To: | Jirka Novak <j(dot)novak(at)netsystem(dot)cz> |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: Sorting by locale settings on Windows? |
| Date: | 2003-07-14 12:17:44 |
| Message-ID: | 20030714121744.GC1268@tishler.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
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
| From: | Jirka Novak <j(dot)novak(at)netsystem(dot)cz> |
|---|---|
| To: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: Sorting by locale settings on Windows? |
| Date: | 2003-07-14 13:16:26 |
| Message-ID: | 3F12AD2A.5020807@netsystem.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
>> 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
| From: | Jason Tishler <jason(at)tishler(dot)net> |
|---|---|
| To: | Jirka Novak <j(dot)novak(at)netsystem(dot)cz> |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: Sorting by locale settings on Windows? |
| Date: | 2003-07-14 18:28:31 |
| Message-ID: | 20030714182831.GB1420@tishler.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
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
| From: | Jason Tishler <jason(at)tishler(dot)net> |
|---|---|
| To: | Jirka Novak <j(dot)novak(at)netsystem(dot)cz> |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: Sorting by locale settings on Windows? |
| Date: | 2003-07-15 11:30:28 |
| Message-ID: | 20030715113027.GB1704@tishler.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
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