Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group