Bug #602: Chinese characters query bug.

Young (young@my-feiqi.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Chinese characters query bug.

Long Description
db=> select objectid, name from state where countryOId=39 and name='xxx' order by name; 
     (Here xxx is a Chinese state word.)

    Then I got the outputs:

 objectid | name 
----------+------
      669 | xxx1
      670 | xxx2
      674 | xxx3
      680 | xxx4
      682 | xxx5
      687 | xxx6
      688 | xxx
...
(12 rows)
    The names are all different in Chinese. You can see from 
the results that the answers are not an unique one. The default 
state choosed the first one. But actually it should be the one whicha's oid = 688.

Sample Code


No file was uploaded with this report