On 25/07/2016 22:54, Geoff Worboys wrote:
> Adriano dos Santos Fernandes wrote:
>> Internally the parameter is WIN1252 (length of 'á' = 1) even the
>> connection charset being UTF8 (where length would be 2).
>> $ isql -ch utf8 -term ! t.fdb
>> Database: t.fdb, User: SYSDBA
> SQL>> create exception ex ''!
> SQL>>
> SQL>> set bulk_insert execute block (
> CON>> i varchar(8) character set win1252 = ?
> CON>> )
> CON>> as
> CON>> begin
> CON>> exception ex octet_length(i);
> CON>> end!
> BULK>> ('á')
>> Statement failed, SQLSTATE = HY000
>> exception 1
>> -EX
>> -1
>> -At block line: 6, col: 3
> What is required to get this example to work?
>
>
You need FB 3/4 snapshot to allow this bulk_insert to work with execute
block.
Adriano
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
