On 28 May 2004 at 14:19, Ivan Prenosil wrote:

>> Talking about syntax, why not just CAST(MyBlob AS BLOB SUB_TYPE
>> 1)?
>
>Although column's default sub_type can be used,
>the syntax should allow specifying both sub_types (FROM/TO).

Any reason? Rephrase your statement a bit and you'll get "Although
column's default type can be used, the /CAST/ syntax should allow
specifying both types" that is nonsence. As you can't store string
into integer field, you can't store different subtype of BLOB.
And answerring another your message: Yes, I think that creating
temporary BLOB is a proper way to go. It must be done at the same
level when coercion of datatypes is performed. I don't see
distinction in kind between setting different sqltype in XSQLVAR and
setting different sqlsubtype. If I request a field to be delivered as
SQL_TEXT, FB obey. It must do the same for BLOB subtypes.

SY, Dimitry Sibiryakov.