Search Postgresql Archives

Re: ENCODING = 'LATIN1' LC_CTYPE?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux