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

"Kasahara Kenichi" <kenjpm90@hotmail.com> 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.0 installation:

CREATE TABLE
INSERT 155246 1
INSERT 155247 1
INSERT 155248 1
 id |     name
----+--------------
 1  | $B$"$"$"(B
(1 row)

 id | name
----+------
(0 rows)

> client_encoding is 'SJIS'.

Um ... you said EUC_JP before.  But I get the same result either way.

            regards, tom lane