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"" <[EMAIL PROTECTED]> wrote > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
