The following bug has been logged online: Bug reference: 1129 Logged by: prasvenk
Email address: [EMAIL PROTECTED] 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 [EMAIL PROTECTED])