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' >

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 -