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

[Adriano d. S. F. <adr...@uo...>]

Leyne, Sean escreveu:
> 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?
Accordingly to the standard:
SUBSTRING(CLOB) -> CLOB
SUBSTRING(BLOB) -> BLOB

The trick to convert BLOBs to [VAR]CHAR didn't work anymore, but it may 
not be necessary in all used cases because now we have compatibility of 
the two types.

In some cases will be necessary to use explicit cast.

-- 
Adriano dos Santos Fernandes
http://www.firebirdsql.org