Re: Locale + encoding combinations - Mailing list pgsql-hackers

From Dave Page
Subject Re: Locale + encoding combinations
Date
Msg-id 470F602E.9060800@postgresql.org
Whole thread Raw
In response to Re: Locale + encoding combinations  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Locale + encoding combinations
List pgsql-hackers
Tom Lane wrote
> That still leaves us with the problem of how to tell whether a locale
> spec is bad on Windows.  Judging by your example, Windows checks whether
> the code page is present but not whether it is sane for the base locale.
> What happens when there's a mismatch --- eg, what encoding do system
> messages come out in?

I'm not sure how to test that specifically, but it seems that accented
characters simply fall back to their undecorated equivalents if the
encoding is not appropriate, eg:

Dave@SNAKE:~$ ./setlc French_France.1252
Locale: French_France.1252
The date is: sam. 01 of août  2007
Dave@SNAKE:~$ ./setlc French_France.28597
Locale: French_France.28597
The date is: sam. 01 of aout  2007

(the encodings used there are WIN1252 and ISO8859-7 (Greek)).

I'm happy to test further is you can suggest how I can figure out the
encoding actually output.

Regards, Dave.


pgsql-hackers by date:

Previous
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: Including Snapshot Info with Indexes
Next
From: Peter Eisentraut
Date:
Subject: Re: Locales and Encodings