Postgres Pro
Downloads
Home   >   mailing lists

Re: equal operator fails on two identical strings if initdb uses the traditional chinese locale - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: equal operator fails on two identical strings if initdb uses the traditional chinese locale
Date
Msg-id 200411241106.22385.peter_e@gmx.net
Whole thread Raw
In response to equal operator fails on two identical strings if initdb uses the traditional chinese locale  (Kent Tong <kent@cpttm.org.mo>)
Responses Re: equal operator fails on two identical strings if initdb
List pgsql-bugs
Tree view 
Kent Tong wrote:
> I'm running PostgreSQL v8 beta4 on Win2K. The default language
> selected in Win2K is Big5.

Big5 is an encoding, not a language.

> I am using the Windows installer to install it. Everything is
> left as default except that the locale for initdb is set to
> "traditional-chinese".
>
> Here is a test (run in pgadmin III):
> 1. createdb db1 -E Unicode

Probably your locale does not support Unicode.  You need to pick an
encoding that matches your locale or vice versa.

> BTW, the locale for traditional chinese in postgresql.conf is
> set to "traditional-chinese" literally. Shouldn't it be
> zh_TW?

That depends on what locale names the Windows operating system
understands.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-bugs by date:

Previous
From: Kent Tong
Date:
Subject: equal operator fails on two identical strings if initdb uses the traditional chinese locale
Next
From: Kent Tong
Date:
Subject: Re: equal operator fails on two identical strings if initdb