BUG #1810: Select * From XXX where xfield = 'Chinese_String'; - Mailing list pgsql-bugs

From willie
Subject BUG #1810: Select * From XXX where xfield = 'Chinese_String';
Date
Msg-id 20050805182842.E8BECF0B06@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1810
Logged by:          willie
Email address:      fmhoyoo@yahoo.com.tw
PostgreSQL version: 8.0.3
Operating system:   Windows XP
Description:        Select * From XXX where xfield = 'Chinese_String';
Details:

version 8.0.3 for Windows XP

Program Language : VB6
Test for "Select  ... where xField='data' ;"


Double Byte Character System : Chinese
return back: EOF (Record not found)

But OK in English


Run pgAdminIII Tools to double check :
The result is correct.

the same example in PostgreSQL-7.3.2-3 for Linux
is correct too.

ps: pardon for my poor English

pgsql-bugs by date:

Previous
From: "yoursoft"
Date:
Subject: BUG #1813: lower() function doesn't work on unicode database
Next
From: "George Jansen"
Date:
Subject: BUG #1811: unique index problem