"Kasahara Kenichi" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings