[fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8
Dennis Poon
dennis at avidsoft.com.hk
Mon Mar 17 08:42:47 CET 2014
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
More information about the fpc-pascal
mailing list