Re: [Firebird-devel] UDF by descriptor - paramdsc.dsc_sub_type - character sets

2016-07-26 Thread Adriano dos Santos Fernandes
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

Re: [Firebird-devel] UDF by descriptor - paramdsc.dsc_sub_type - character sets

2016-07-26 Thread Adriano dos Santos Fernandes
On 26/07/2016 02:49, Geoff Worboys wrote: >> Internally the parameter is WIN1252 (length of 'á' = 1) even the >> connection charset being UTF8 (where length would be 2). > Can you find a way to try the equivalent of this: > > EXECUTE BLOCK ( > i VARCHAR(60) CHARACTER SET WIN1252 = ? > ) RETURNS

Re: [Firebird-devel] UDF by descriptor - paramdsc.dsc_sub_type - character sets

2016-07-26 Thread Adriano dos Santos Fernandes
On 26/07/2016 08:00, Adriano dos Santos Fernandes wrote: > On 26/07/2016 02:49, Geoff Worboys wrote: >>> Internally the parameter is WIN1252 (length of 'á' = 1) even the >>> connection charset being UTF8 (where length would be 2). >> Can you find a way to try the equivalent of this: >> >> EXECUTE B

Re: [Firebird-devel] UDF by descriptor - paramdsc.dsc_sub_type - character sets

2016-07-26 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: > My test is a bit different as bulk_insert cannot be used with > output parameters. Here is it: > set bulk_insert EXECUTE BLOCK ( > i VARCHAR(60) CHARACTER SET WIN1252 = ? > ) AS > declare r VARCHAR(60) CHARACTER SET WIN1252; > DECLARE v VARCHAR(60)

[Firebird-devel] IAttachment::openCursor with single result

2016-07-26 Thread Dimitry Sibiryakov
Hello, All. What must to do openCursor() if it is called with statement that do not return cursor, such as execute procedure or update returning? -- WBR, SD. -- What NetFlow Analyzer can do for you? Monitors