Re: [ADMIN] Postgresql 8.1.3 Debian installation encoding question

2006-03-26 Thread Peter Eisentraut
Joost Kraaijeveld wrote: > 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 >

RE: [ADMIN] Postgresql 8.1.3 Debian installation encoding question

2006-03-26 Thread Joost Kraaijeveld
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,

Re: [ADMIN] Postgresql 8.1.3 Debian installation encoding question

2006-03-26 Thread Peter Eisentraut
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 w

Re: [ADMIN] Postgresql 8.1.3 Debian installation encoding question

2006-03-26 Thread Joost Kraaijeveld
On Sun, 2006-03-26 at 10:20 +0200, Peter Eisentraut wrote: > It's derived from the locale, so make sure all your locales are set up > correctly. 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. My locales are: [E

Re: [ADMIN] Postgresql 8.1.3 Debian installation encoding question

2006-03-26 Thread Peter Eisentraut
Joost Kraaijeveld wrote: > How can I change that? Why did the Debian encoding change? It's derived from the locale, so make sure all your locales are set up correctly. > Can I > still use the Debian deb files or must I manually initdb PostgreSQL? These options are not exclusive. -- Peter Eis