From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to insert non-english characters to the db? |
Date: | 2003-09-08 22:53:53 |
Message-ID: | 7524.1063061633@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tomka Gergely | 2003-09-09 06:00:17 | Re: How to insert non-english characters to the db? |
Previous Message | Andreas Fromm | 2003-09-08 22:25:38 | Re: How to insert non-english characters to the db? |