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?
In both FB2.5.6 and FB3 (under Windows) I get:
"Only INSERT commands are accepted in bulk mode"
(Any example that would let me run EXECUTE BLOCK with a
parameter in isql would help.)
--
Geoff Worboys
Telesis Computing Pty Ltd
------------------------------------------------------------------------------
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
