--- In firebird-support@yahoogroups.com, "Mercea Paul"
<paul.mercea@...> wrote:

>
> Hi
>
>
>
> I have tried with
>
> CREATE TABLE CAS_TEST (
>
> ID_TEST ID /* ID = BIGINT */,
>
> IMAGE BLOB SUB_TYPE 0 SEGMENT SIZE 32762
>
> }
>
>
>
> And works ok inserting 10 mb picture if you need!
>
>
>
> Regards,
>
> Paul

Thanks Paul:

I replaced the blob declaration in my CREATE TABLE with
one setting the sub type to 0 and the size to 32762.

CON_IMAGE BLOB SUB_TYPE 0 SEGMENT SIZE 32762

I'm getting the same message.

I also checked the image_size value being passed to

image_blob->Write(image_buffer, image_size);

It is 699914.

I am using an existing table. It's a wide table. I
had to cut back the size of some of my varchars to make
Firebird happy. Could the width of the table cause this
blob problem?

Thanks
Larry

>
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of inoffensive_2006
> Sent: 31 May 2008 13:25
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Blob - Invalid segment size
>
>
>
> Hi Folks:
>
> Developing code on Win XP Home, Visual Studio 2008 Pro, C++.
> Using Firebird 2.0.1.1285, and IBPP.
>
> I have image data that I've been saving to the database with no
> problem. These images are about 40 KB.
>
> My partner's wife has a new 10 Mega Pixel camera. The one image we
> are using from that camera is 684 KB.
>
> With larger images to save in blobs, IBPP is throwing exceptions
> with this text:
>
> Context: Blob::Write
> Message: Invalid segment size (max 64Kb-1)
>
> Documents I read suggests that the segment size of a blob is
> irrelevant.
>
> I defined a blob as:
>
> CON_IMAGE BLOB SUB_TYPE -3
>
> The sub type is my own enumerator, for graphic data.
>
> After this problem started I tried:
>
> CON_IMAGE BLOB SUB_TYPE -3 SEGMENT SIZE 25000
>
> And I also tried a size if 2500.
>
> I'm getting the same error.
>
> The code to write the blob looks like this:
>
> image_blob =
> IBPP::BlobFactory(
> database_record_ptr->get_database_id(),
> selected_transaction_ptr->transaction);
>
> image_blob->Create();
>
> image_blob->Write(image_buffer, image_size);
>
> image_blob->Close();
>
> st->Set(1, image_blob);
>
> The exception is thrown on the Write statement.
>
> Suggestions?
>
> Thanks
> Larry
>
>
>
>
>
> [Non-text portions of this message have been removed]
>