Adriano dos Santos Fernandes wrote:
> On 22/07/2016 08:38, Geoff Worboys wrote:
>> the other regarding EXECUTE BLOCK parameters:
> You did not put full test case here, so I do not know what
> you mean.
> Of course, parameters are converted to client charset, even
> if they use explicit character sets.
I did wonder if I was getting confused with regard to the
client-side behaviour for EXECUTE BLOCK. Try this example
(which is what I put on tracker), it has no external domains:
EXECUTE BLOCK (
"Param1" VARCHAR(80) CHARACTER SET WIN1252 = ?
) RETURNS (
"Result" VARCHAR(255)
) AS
BEGIN
"Result" = ReflectType("Param1");
SUSPEND;
END
This, like my previous example, reflects the type of Param1
as being character set 127 (ttype_dynamic).
Assuming this block is compiled and executed on the server
rather than the client, then the UDF inside the block should
not see the attachment character set at all, but only the
declared character set of Param1 - so why is it seeing
ttype_dynamic? Am I missing something?
I figured the full source code to the ReflectType UDF. was
overkill. The UDF simply reads the paramdsc.dsc_sub_type of
the input parameter and reports the character set (amongst
other details). It was written mainly for experimental
purposes. It works, but it's too messy to want others to
see it ;-) ... and it's written in Delphi
--
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
