Dennis Poon wrote / napĂsal(a):
Dennis Poon wrote:
Michael Van Canneyt wrote:
On Fri, 14 Mar 2014, Dennis Poon wrote:
the content appeared as garbage.
I already specified the CHARSET=utf8 in the Create Table SQL.
Did you set the TSQLConnection.Charset property to UTF8 as well ?
I set it to utf8 (UTF-8 will raise exception) but still appears as
garbage.
I wrote a test UI program use TDBGrid to edit the text with chinese
and then refresh it.
So when you first time read data from MySQL then they are displayed
correctly.
And only after editing, Posting, ApplyingUpdates and reading back are
character data displayed incorrectly ?
The chinese text, after refreshing, appears as ???
I even tried TSQLScript but it also failed and the chinese values
appear as ??? in the updated record.
I suspect that TSQLConnection (or only when it works with MYSQL)
failed to handle multi-byte charset.
MySQL Connection only takes string data as are stored in TField (or
TParam) and forwards them to underlying mysql client library.
Can you prepare any simple test application (with CREATE TABLE, fill
data etc.) which will show problem ?
-Laco.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal