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

Dennis Poon dennis at avidsoft.com.hk
Tue Mar 25 09:56:48 CET 2014


>>
>> By the way, why isn't a semicolon required at the end of SET NAMES 
>> 'utf8' command? I tried both with and without semicolon and neither 
>> raise an error.
> Seems, that MySQL is tolerant to this.
> MySQL supports MULTI_STATEMENTS, which enables client to pass multiple 
> statements separated by ";" in one string.
> So may be, that MySQL interprets ";" as delimiter between multiple 
> statements on one batch.
> If you use only one sql statement it is always better do not use 
> terminating ";" IMHO
>
> -Laco.
>
The strange thing is, when we use MYSQL's interactive command line 
client, a semi colon is always required for EACH SQL Statement.

Dennis



More information about the fpc-pascal mailing list