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.
The chinese text, after refreshing, appears as ???
Dennis
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.
I tried to step into the ApplyUpdates but the debugger did not go into
the procedure. Don't know why.
Dennis
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
