Bug #602: Chinese characters query bug.

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #602: Chinese characters query bug.
Date: 2002-02-25 01:48:14
Message-ID: 20020225014814.974E8475992@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Young (young(at)my-feiqi(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2002-02-25 01:54:25 Re: Bug #602: Chinese characters query bug.
Previous Message Lee Harr 2002-02-25 00:58:32 missing foreign key fails silently using COPY

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2002-02-25 01:54:25 Re: Bug #602: Chinese characters query bug.
Previous Message Bruce Momjian 2002-02-25 01:45:40 Re: elog() proposal