Re: ENCODING = 'LATIN1' LC_CTYPE?

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