A couple of questions about blob-types.

Can I specify a blob as just a "blob"?

for example, in a table can I have a field defined as:

....
blob_field blob not null,
.....

...or do I have to specify sub_type and other options like so:

.....
blob_field blob segment sub_type text segment size 1024 not null,
.....

And, when referring to that field in a stored procedure parameter, can I
just call it a "blob"? For example:

CREATE PROCEDURE sel_prod_by_prod_option_id

(

product_option_id int

)

returns

(

product_id_ int,

product_name_ varchar(50),

product_num_ varchar(50),

synopsis_ varchar(500),

description_ blob,

.................,

...or would I also have to specify all options?

I ask because I think my C# code is throwing exceptions (I can find no other
reason why it wouldn't work) - when I try to insert into a table w/ a blob
field simply defined as "blob", without sub_type or segment options.

Thanks all!



[Non-text portions of this message have been removed]