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

Dennis Poon dennis at avidsoft.com.hk
Thu Mar 20 15:24:34 CET 2014


>> 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



More information about the fpc-pascal mailing list