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.
The chinese text, after refreshing, appears as ???
... And
Can you please after connection is established check values of these
system variables:
character_set_client , character_set_connection, character_set_database
by
select @@character_set_client , @@character_set_connection,
@@character_set_database;
-LACO.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal