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@xxxxxxxxxxxxx>
To: <ttina@xxxxxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Sunday, February 13, 2005 1:48 PM
Subject: Re: problem with thai language
> <ttina@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
