Adriano, > > By "type" does the standard mean the basic data type as well as the > length? > > > I mean the "max length". It always returns blob for blobs and varchar for > others types.
Then it seems that the reported case must be about a blob column, since a substring on a char or varchar column would not raise the error. (I have asked the OP to confirm the column definition, since they did not include that detail). In the case of a source value of type blob, I think that the current handling is correct (we return a blob for a blob) and that the case should be resolved "as designed" (MS SQL and DB2 treats SUBSTRING on blob the same as FB; I suspect Oracle and PostgresSQL will be the same). Sean ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
