| Subject | Re: [firebird-support] how to use BLOBs |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-03-15T22:05Z |
At 09:53 PM 15/03/2007, you wrote:
otherwise) directly with DSQL.
select MyBlob from MyTable
where ....
insert into MyTable (ID, MyBlob)
values (?, ?)
For BLOB sub_type 1 (TEXT), the blob argument can take a string of
32,765 bytes or less. This is more (or less) useful, provided you
are not trying to store strings that might be larger than that.
use a different API structure from the one for regular
data. Subscribe to the firebird-net-provider list. All the
list-subscribe instructions are at http://firebirdsql.org/index.php?op=lists
./heLen
>Why using procedural SQL? You can store and retrieve blobs (text or
>
>Hi all,
>
> Could anyone post an example of how to store and retreive CLOBs (BLOB
>subtype TEXT) using procedural SQL or similar?
otherwise) directly with DSQL.
select MyBlob from MyTable
where ....
insert into MyTable (ID, MyBlob)
values (?, ?)
For BLOB sub_type 1 (TEXT), the blob argument can take a string of
32,765 bytes or less. This is more (or less) useful, provided you
are not trying to store strings that might be larger than that.
>Any hints on how to perform the same operation through the .NET driver?I think this is what you really need to know, since BLOB operations
use a different API structure from the one for regular
data. Subscribe to the firebird-net-provider list. All the
list-subscribe instructions are at http://firebirdsql.org/index.php?op=lists
./heLen