| Subject | Re: [firebird-support] Converting A Blob To A String Within A SP |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-11-09T09:14:41Z |
At 09:26 AM 9/11/2005 +0100, you wrote:
./hb
> >>also i cant cast the blob as a firebird varchar data type because itWorks here on Firebird 1.5.2, Ivan. :-))
> >>might be too big for that.
> >>
> >>
> > You can use substring, it converts a blob to varchar
> >
> > Substring(MyBlob from 1 for 1024)
>
>Yes, but it works only in Firebird 2.
./hb