BUG #1810: Select * From XXX where xfield = 'Chinese_String';

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

BUG #1810: Select * From XXX where xfield = 'Chinese_String';

willie-2

The following bug has been logged online:

Bug reference:      1810
Logged by:          willie
Email address:      [hidden email]
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

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