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

[Dennis Poon]

LacaK wrote:
> 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.
>
I tried, the results are:

@@character_set_client      : utf8
@@character_set_connection  : latin1
@@character_set_database   : latin1


Dennis