The following bug has been logged online:

Bug reference: 1908
Logged by: wally
Email address: wally (AT) ideassoft (DOT) com
PostgreSQL version: 8.0.3,8.0.2
Operating system: fc4,fc3,as4
Description: sql support chinese char error
Details:

when running the following sql clause,the result shoud be empty, but I get
one incorrect row.
if I use pgsql 7.4 running the same sql clause return correctly.
thanks!

ulike=# select group_name from group_info where group_name='士大夫';
group_name
------------
大长今
(1 row)

ulike=# select group_name from group_info ;
group_name
-------------
fFaf
asgfasf
hjlhjl
dfgdj
俺å�«é*�淑芬
大长今
fdkfjwr
beijing2008
wws
dhdfj
士大夫感
(11 rows)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

It looks strange. Can you show us more information:

1. Database encoding: show server_encoding;
2. SQL scripts do create and insert the values.

""wally"" <wally (AT) ideassoft (DOT) com> wrote


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster