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