"Kasahara Kenichi" <kenjpm90(at)hotmail(dot)com> writes:
> Our development environment is
> Server OS: Red Hat Enterprise Linux ES 3
> DB : PostgreSQL 8.0.4
> both encodes are EUC_JP
What locale is the database using? Strange comparison behavior is
fairly common if the locale expects a different encoding than you
are using...
regards, tom lane