Re: locales and encodings on Windows - Mailing list pgsql-hackers-win32

From Aleksander Kmetec
Subject Re: locales and encodings on Windows
Date
Msg-id 4193C607.1040102@intera.si
Whole thread Raw
In response to Re: locales and encodings on Windows  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: locales and encodings on Windows
List pgsql-hackers-win32
Magnus Hagander wrote:
> Do you know enough to say exactly which locale/encoding
> combinations have to be removed fromt he installer?

The encodings are:
UTF8
EUC_CN
EUC_TW
LATIN6 (ISO 8859-10/ECMA 144)
LATIN7 (ISO 8859-13)
LATIN8 (ISO 8859-14)
LATIN10 (ISO 8859-16/ASRO SR 14111

While you can still create databases using these encodings, it's not
possible to initb with a locale that uses the same encoding. This means
ORDER BY, UPPER() and similar will produce wrong results.

I guess I'll resubmit my installer patch for listing locales supported
by the system, this time without the encodings listed above. That way
most users won't see unsupported encodings, while people who know what
they're doing can still reach them by using CREATE DATABASE newdb
ENCODING 'encoding'.

>>Last October there was a discussion on pgsql-hackers about
>>writing locale support for PG, so it wouldn't depend on the
>>system for locale functionality any more. Is anyone still
>>working on that?
>
> I have no idea, but I'm certain if someone is this is definitly not
> going to happen for 8.0.

I know this feature can't make it into 8.0; but blaming Windows for more
than one release cycle might not look very good. :-(

Regards,
Aleksander

pgsql-hackers-win32 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: locales and encodings on Windows
Next
From: Rob McCarthy
Date:
Subject: Initdb Fail installing PostgreSQL 8.0.0 Beta 4