Re: Strange query results with invalid multibyte

On Wed, 2006-09-27 at 12:10 -0400, Tom Lane wrote:
> Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> 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
Ah, sorry: "show lc_collate" and "show lc_ctype" confirm your guess.

> 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 :-(
I am not sure what you mean by that but maybe this helps:

the output of "locale" on the working machine is:

LANG=
LANGUAGE=en_US:en_GB
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

The output of the same command on the non-working machine:

LANG=en_US
LANGUAGE=en_NL:en_US:en_GB:en
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE="en_US"
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=

If this is not what you mean, could you help me in the right direction?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl