Thread: BUG #1129: select query returns multiple results for a japanese characters

The following bug has been logged online:

Bug reference:      1129
Logged by:          prasvenk

Email address:      prasvenk@yahoo.com

PostgreSQL version: 7.4

Operating system:   rehat linux 9

Description:        select query returns multiple results for a japanese
characters

Details:

Hi,
I tried the following query on a windows 2000 machine with cywin and
postgres 7.4

select * from colour_master where colour_name='シンギン ';

this returned one row which is correct.

i passed the same query to a same database but on a linux machine with
postgres 7.4.2 it returned me around 5 rows which is not correct .

these are the rows which were returned.
オレンジ
もみじ赤
もみじ黄
赤土白地
シンギン

Any kind of help will the appreciable.

Thanks in advance.
Regards,
Prasvenk

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> i passed the same query to a same database but on a linux machine with
> postgres 7.4.2 it returned me around 5 rows which is not correct .

I'd guess that you are using the wrong character set encoding in the
Linux database.  You did not say what encoding you think these strings
are in, but it seems possible that strings containing characters that
are illegal in the current encoding might be considered equal.

            regards, tom lane