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

[LacaK]

Dennis Poon  wrote / napísal(a):
>
>
> 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 ???
>>
... And
Can you please after connection is established check values of these 
system variables:
  character_set_client , character_set_connection, character_set_database
by
  select @@character_set_client , @@character_set_connection, 
@@character_set_database;
-LACO.