FAQ
The following bug has been logged online:

Bug reference: 1695
Logged by: philip
Email address: philipguo@yahoo.com
PostgreSQL version: 8.0.3
Operating system: MS Windows XP sp1 and Linux Fedora core 3
Description: "select distinct" makes different output
Details:

Hi there,

I installed PostgreSQL 8.0.3 database system on both platforms MS Windows XP
(sp1) and Linux Fedora 3, and both databse settings are exactly the same
with the encoding set to 'UNICODE'. Both database systems are running well
except one thing so far has the different results from those two databases.
Here is a query as the example:

select distinct area from ht_booking.hotels;

The result from the database on Linux FC3 has no problem but the one on
Windows XP. The data output from the later have the duplicated rows. It
seems to make no difference with or without "distinct" key word. BUT, this
happens only under one condition: the data in that column contains chinese
characters.

Please feel free to question me if there is anything I can do to help with.
Thank you.

Search Discussions

  • Magnus Hagander at Jun 1, 2005 at 3:20 pm

    The following bug has been logged online:

    Bug reference: 1695
    Logged by: philip
    Email address: philipguo@yahoo.com
    PostgreSQL version: 8.0.3
    Operating system: MS Windows XP sp1 and Linux Fedora core 3
    Description: "select distinct" makes different output
    Details:

    Hi there,

    I installed PostgreSQL 8.0.3 database system on both
    platforms MS Windows XP
    (sp1) and Linux Fedora 3, and both databse settings are
    exactly the same with the encoding set to 'UNICODE'. Both
    database systems are running well except one thing so far has
    the different results from those two databases.
    Here is a query as the example:

    select distinct area from ht_booking.hotels;

    The result from the database on Linux FC3 has no problem but
    the one on Windows XP. The data output from the later have
    the duplicated rows. It seems to make no difference with or
    without "distinct" key word. BUT, this happens only under one
    condition: the data in that column contains chinese characters.

    Please feel free to question me if there is anything I can
    do to help with.
    Thank you.
    Whare are your database encoding and locale in the two different
    installations?

    //Magnus
  • Tom Lane at Jun 1, 2005 at 3:36 pm

    "philip" <philipguo@yahoo.com> writes:
    I installed PostgreSQL 8.0.3 database system on both platforms MS Windows XP
    (sp1) and Linux Fedora 3, and both databse settings are exactly the same
    with the encoding set to 'UNICODE'.
    Windows' support for UNICODE is kind of broken I'm afraid :-(. You
    should use a different encoding on that platform, at least until we
    figure out an end-run around the OS' limitations.

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedJun 1, '05 at 12:39a
activeJun 1, '05 at 3:36p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase