The following bug has been logged online: Bug reference: 1908 Logged by: wally Email address: [EMAIL PROTECTED] 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