[GENERAL] Strange query results with invalid multibyte character

2006-09-27 Thread Joost Kraaijeveld
Hi, I have a strange problem. I have 2 database, both created with: CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default; Running the queries below on the first database is OK and do what I expect. If I create a backup of the first datase and restore that

Re: [GENERAL] Strange query results with invalid multibyte character

2006-09-27 Thread Tom Lane
Joost Kraaijeveld [EMAIL PROTECTED] writes: I have 2 database, both created with: CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default; But have they got the same locale settings (lc_collate, lc_ctype)? regards, tom lane

Re: [GENERAL] Strange query results with invalid multibyte character

2006-09-27 Thread Tom Lane
Joost Kraaijeveld [EMAIL PROTECTED] writes: On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote: But have they got the same locale settings (lc_collate, lc_ctype)? According to the postgresql.conf of the *working* database the locales are: lc_messages = 'C' lc_monetary = 'C'