> The following bug has been logged online: > > Bug reference: 1695 > Logged by: philip > Email address: [EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
