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

From wally
Subject BUG #1908: sql support chinese char error
Date
Msg-id 20050926090827.9E7F1F0DD3@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
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)

pgsql-bugs by date:

Previous
From: "Abel Pinto Muñoz"
Date:
Subject: BUG #1911: Error in PSQLODBC.DLL using SQLTablePrivileges
Next
From: "Michael Kappler"
Date:
Subject: BUG #1907: problem with function return as integer[]