Re: ENCODING = 'LATIN1' LC_CTYPE? - Mailing list pgsql-general

Sylvia Preuß wrote:
> I’d like to create a database with ENCODING LATIN1 .
> 
> CREATE DATABASE z_latin1
>   WITH OWNER = admin
>        ENCODING = 'LATIN1'
>        TABLESPACE = pg_default
>        LC_COLLATE = 'German_Germany.1252'
>        LC_CTYPE = 'German_Germany.1252'
>        CONNECTION LIMIT = -1;
> 
> FEHLER: Kodierung »LATIN1« stimmt nicht mit Locale »German_Germany.1252« überein
> SQL Status:22023
> Detail:Die gewählte LC_CTYPE-Einstellung verlangt die Kodierung »WIN1252«.
> 
> PostgreSQL 9.2.8, compiled by Visual C++ build 1600, 64-bit
> 
> Which LC_COLLATE and LC_CTYPE entry do I need to fit latin1?
> (It won’t help to set the encoding to UTF8.)

Try German_Germany.28591

See http://msdn.microsoft.com/en-us/library/windows/desktop/dd317756%28v=vs.85%29.aspx

Yours,
Laurenz Albe