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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Kent Tong <kent(at)cpttm(dot)org(dot)mo>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: equal operator fails on two identical strings if initdb uses the traditional chinese locale
Date: 2004-11-24 10:06:22
Message-ID: 200411241106.22385.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kent Tong 2004-11-24 10:39:53 Re: equal operator fails on two identical strings if initdb
Previous Message Kent Tong 2004-11-24 08:25:14 equal operator fails on two identical strings if initdb uses the traditional chinese locale