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

LacaK lacak at zoznam.sk
Thu Mar 20 09:34:43 CET 2014


Dennis Poon  wrote / napĂ­sal(a):
>
>
>>
>>
> 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20140320/f675394c/attachment.html>


More information about the fpc-pascal mailing list