> 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 locale" when I initialize
database?

regards, Kenichi Kasahara

__________________________________________________ _______________
$BL5NA$G(B250MB$B$N<u?.%\%C%/%9$,;H$($k!V(BMSN Hotmail$B!W(B
http://promotion.msn.co.jp/hotmail/


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

"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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org