The following bug has been logged online:

Bug reference: 1129
Logged by: prasvenk

Email address: prasvenk (AT) yahoo (DOT) 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend