[Firebird-devel] SELECT SUBSTRING( Blob_Field FROM x to y)... yields Blob_Field??

[Leyne, S. <Se...@br...>]

All,

I know that much work was done in v2.1 to makes text blobs 'compatible'
with Varchar/Char fields, but I have a concern about the SUBSTRING
function.

As noted in the subject above, SUBSTRING of a blob returns a blob.  This
seems... wrong.

Given the name of the function (SUB *String*) and its limitation (max
length of return value is 32KB), I believe that the function should
return a Varchar and not a Blob.

Comments?


Sean

P.S.	I know it is rather/extremely late in the v2.1 cycle to be
raising this issue, and I apologize for being late to the party.