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

[Dennis Poon]

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