| Subject | Re: [firebird-support] Blob manipulation in SP |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-10-22T04:22:42Z |
At 02:21 AM 22/10/2003 +0000, you wrote:
about the content, beginning, middle, end, whatever. Regardless of how you
solve it, you cannot concatenate two blobs or append a string to a
blob. You have to get the blob into some kind of application environment
that can convert it back to text, append your string and send the resulting
longer byte stream back to the database as a blob - it will be stored as a
different blob, with a new blob_id and all.
A UDF would be more network-friendly than a client-side solution.
h.
>I'**********You will have to. The engine simply stores blobs, it has no intelligence
>
>Now I know this doesn't even compile at this time. Any suggestions as
>to how I would get this to work?
>
>I would *rather not* have to go to a UDF solution if possible. I will
>if I have to.
about the content, beginning, middle, end, whatever. Regardless of how you
solve it, you cannot concatenate two blobs or append a string to a
blob. You have to get the blob into some kind of application environment
that can convert it back to text, append your string and send the resulting
longer byte stream back to the database as a blob - it will be stored as a
different blob, with a new blob_id and all.
A UDF would be more network-friendly than a client-side solution.
h.