Re: How to insert non-english characters to the db?

Поиск
Список
Период
Сортировка
От Andreas Fromm
Тема Re: How to insert non-english characters to the db?
Дата
Msg-id 3F5D01E2.6040007@physik.uni-erlangen.de
обсуждение исходный текст
Ответ на How to insert non-english characters to the db?  (Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>)
Ответы Re: How to insert non-english characters to the db?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to insert non-english characters to the db?  (Tomka Gergely <tomka@zeus.gau.hu>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Modifying pg_shadow?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to insert non-english characters to the db?