Обсуждение: Sorting by locale settings on Windows?
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
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
>> 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
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
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
> 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