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

[Dennis Poon]

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