> > 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.

The "Segment Size" value is no longer of any real significance for
modern applications, it is for support of real legacy applications (ie.
ancient).

A value of 80 is fine for all purposes.


Sean