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

Aarni Ruuhimäki wrote:

>Hi,
>
>I got my sorting and non-english characters working ok with
>
>./configure --enable-locale
>
>and with
>
>initdb --locale=fi_FI -E LATIN1
>
>and just to make sure all databases created with ENCODING = 'LATIN1'
>
>You probably need to replace locale=fi_FI with locale=de_DE or something
>similar.
>
>BR,
>
>Aarni
>
>
Thanks for all the replies, but I'm still having problems. I recompiled
postgres with

./configure --enable-locale --enable-nls='en de'

and made an

initdb --locale=de_DE -E UNICODE (tryed LATIN1 also)

but when starting the postmaster I get the following message:

FATAL:  invalid value for "lc_messages": "de_DE"
postmaster successfully started

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?

Regards

Andreas