"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
