Joost Kraaijeveld <J.Kraaijeveld@xxxxxxxxxx> 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' > lc_numeric = 'C' > lc_time = 'C' > According to the other obe: > lc_messages = 'en_US' > lc_monetary = 'en_US' > lc_numeric = 'en_US' > lc_time = 'en_US' You did not show us the settings that actually count, but based on this I'm guessing they are en_US also. What you need to find out next is what character set encoding that locale implies on your machine. I'm betting it's not utf8 though :-( regards, tom lane
