[fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8
LacaK
lacak at zoznam.sk
Tue Mar 18 10:56:52 CET 2014
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.
More information about the fpc-pascal
mailing list