Re: Postgresql 8.1.3 Debian installation encoding question

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>, "Debian users" <debian-user(at)lists(dot)debian(dot)org>
Subject: Re: Postgresql 8.1.3 Debian installation encoding question
Date: 2006-03-26 18:46:07
Message-ID: A3D1526C98B7C1409A687E0943EAC410605FCE@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Peter Eisentraut wrote:
> Joost Kraaijeveld wrote:
>> OK, but how is it derived? As far as I know, I did not change
>> anything in the locales since the previous time I installed
>> PostgreSQL.
>
> If your locale is POSIX then it will choose SQL_ASCII. So there is
> nothing wrong in PostgreSQL, it's just that your locale is
> not what you apparently need.
I was certainly not implying that PostgreSQL was at fault (I wouldn't dare on a PostgreSQL mailinglist ;-) ).

But I cannot find where I have to configure what locale in the OS to get UTF8 as default encoding for the databases. (I read http://www.postgresql.org/docs/8.1/static/multibyte.html but that did not give me that info). Can you tell me this or give me a pointer to the answer?

TIA

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2006-03-26 20:06:13 Re: Postgresql 8.1.3 Debian installation encoding question
Previous Message Peter Eisentraut 2006-03-26 17:42:26 Re: Postgresql 8.1.3 Debian installation encoding question