The following bug has been logged online:
Bug reference: 1908
Logged by: wally
Email address: wally@ideassoft.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)