Thread: BUG #1908: sql support chinese char error

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)

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
>