Re: [BUGS] There is a doubt of fatal bug on PostgreSQL 8.0.4.

2005-12-09 Thread Tom Lane
"Kasahara Kenichi" <[EMAIL PROTECTED]> writes: >> What locale is the database using? Strange comparison behavior is >> fairly common if the locale expects a different encoding than you >> are using... > locale is 'C'. Hm, it should work OK with C locale. I get apparently-correct output on my 8.

Re: [BUGS] There is a doubt of fatal bug on PostgreSQL 8.0.4.

2005-12-09 Thread Kasahara Kenichi
What locale is the database using? Strange comparison behavior is fairly common if the locale expects a different encoding than you are using... locale is 'C'. client_encoding is 'SJIS'. Locale 'C' is the same settings when I used version 8.0.3. I think this is right..Or should I appoint "no l

Re: [BUGS] There is a doubt of fatal bug on PostgreSQL 8.0.4.

2005-12-08 Thread Tom Lane
"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 t