"cnliou" <cnliou(at)so-net(dot)net(dot)tw> writes:
> Linux 2.4.23 on AMD 450MHz.
> pgsql 7.4.1
> configure --enable-multibyte=UNICODE
> locale is zh_TW.Big5
> IIRC, when I did "initdb -E UNICODE" or "createdb db1", I
> saw the following message from pgsql:
> ...locale "C"...
Uh ... you're being self-contradictory about the locale setting.
Please show us the result of "show lc_collate" and "show lc_ctype"
just to remove doubt.
Also, it's hard to reproduce your example when we don't know the
data types of the table columns...
regards, tom lane