Re: BUG #1908: sql support chinese char error - Mailing list pgsql-bugs

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@ideassoft.com> wrote
>
> 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)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>