Re: equal operator fails on two identical strings if initdb uses the traditional chinese locale

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/