Not sure what version of PostgreSQL or what kind of platform you are using, I would say this may be a bug with the locale database of your OS. Try disable locale support of PostgreSQL. -- Tatsuo Ishii
> Young ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > Chinese characters query bug. > > Long Description > db=> select objectid, name from state where countryOId=39 and name='xxx' order by >name; > (Here xxx is a Chinese state word.) > > Then I got the outputs: > > objectid | name > ----------+------ > 669 | xxx1 > 670 | xxx2 > 674 | xxx3 > 680 | xxx4 > 682 | xxx5 > 687 | xxx6 > 688 | xxx > ... > (12 rows) > The names are all different in Chinese. You can see from > the results that the answers are not an unique one. The default > state choosed the first one. But actually it should be the one whicha's oid = 688. > > Sample Code > > > No file was uploaded with this report > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
