Re: BUG #1908: sql support chinese char error

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(at)ideassoft(dot)com> wrote
>
> The following bug has been logged online:
>
> Bug reference: 1908
> Logged by: wally
> Email address: wally(at)ideassoft(dot)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
>