Thread: problem with thai language

<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

Hi Tom lane
    How can I get in deep about locale and encoding?
Please advise url or resource!
thanks for your kindness
tina

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: <ttina@access.inet.co.th>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, February 13, 2005 1:48 PM
Subject: Re: [GENERAL] problem with thai language


> <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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>