Re: problem with thai language - Mailing list pgsql-general

From Tom Lane
Subject Re: problem with thai language
Date
Msg-id 26547.1108277338@sss.pgh.pa.us
Whole thread Raw
In response to problem with thai language  (<ttina@access.inet.co.th>)
List pgsql-general
<ttina@access.inet.co.th> writes:
>     I use postgresql7.2 / redhat8
> I try "select 'X1'='X2' ;" and X1=(D button) in thai language, =
> X2=(8 button) in thai language
>   result is true .This is wrong result!.

We've seen a lot of reports of bizarre behavior when you select a
database encoding that does not match the character set implied by
the locale setting you're using.  Apparently strcoll() on many platforms
goes nuts when handed input that is not legally encoded according to
what it thinks the character set is.

In short: check your locale and your encoding.

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Apparent anomaly with views and unions
Next
From: Tom Lane
Date:
Subject: Re: Apparent anomaly with views and unions