On 23/07/2016 04:03, Geoff Worboys wrote:
>
> "Param1" = TmpUtf8; -- <<< Expect Error Here
>
Do not understand what you mean with that. And I'm always lost myself in
your verbosity.
Here is what I get and is IMO completely correct as Dmitry explained to you.
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 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
