Re: How to insert non-english characters to the db? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How to insert non-english characters to the db?
Date
Msg-id 7524.1063061633@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to insert non-english characters to the db?  (Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>)
List pgsql-novice
Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de> writes:
> initdb --locale=de_DE -E UNICODE (tryed LATIN1 also)
> FATAL:  invalid value for "lc_messages": "de_DE"

> I'm on a debian/linux box that has many apps with different
> localisations availabel. Does the newest version PgSQL 7.4beta not have
> the localisation support jet?

No, your problem is that your OS doesn't have complete support for de_DE
locale.  You will need to pick a supported locale for LC_MESSAGES.  I'd
recommend something along the lines of

    export LC_ALL=de_DE
    export LC_MESSAGES=C        -- or something else that works
    initdb -E UNICODE

You could try just editing the lc_messages setting in postgresql.conf,
but I am not sure whether that will be sufficient; the original initdb
may have suffered internal failures due to the broken locale setting.
Safest to redo it.

            regards, tom lane

pgsql-novice by date:

Previous
From: Andreas Fromm
Date:
Subject: Re: How to insert non-english characters to the db?
Next
From: Tomka Gergely
Date:
Subject: Re: How to insert non-english characters to the db?