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.Kraaijeveld@xxxxxxxxxx web: www.askesis.nl
