Bug #602: Chinese characters query bug. - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #602: Chinese characters query bug.
Date
Msg-id 20020225014814.974E8475992@postgresql.org
Whole thread Raw
Responses Re: Bug #602: Chinese characters query bug.
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] COPY when 'filename' is a directory
Next
From: Tatsuo Ishii
Date:
Subject: Re: Bug #602: Chinese characters query bug.