[fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8

[Dennis Poon]

>> I tried, the results are:
>>
>> @@character_set_client      : utf8
>> @@character_set_connection  : latin1
>> @@character_set_database   : latin1
>>
>>
> Dennis, do you received my reply?:
>
> IMO @@character_set_connection is wrong and must be utf8.
> I will try fix it, but first can you try as workaround this:
> - after connection is established can you use 
> MySQLConnection1.ExecuteDirect('SET NAMES ''utf8''');
> - and then check again @@character_set_client, 
> @@character_set_connection (IMO both must be utf8 ... if they will be, 
> then your program should work as expected ... can you test it again?)
>
> -Laco.
>
I tried  MYSQLConnection1.ExecuteDirect('SET NAMES ''utf8'';');
and recheck
   @@character_set_client    : utf8
   @@character_set_connection : utf8
   @@character_set_database : latin1

So, it corrected one variable.

I re-ran my test but still  ?????? after applyUpdates.

Dennis