This is a discussion on BUG #1810: Select * From XXX where xfield = 'Chinese_String'; within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 1810 Logged by: willie Email address: fmhoyoo@yahoo.com.tw PostgreSQL version: 8.0.3 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |