It has to do with segmented blobs and the prefferred size of the individual
segments when fetching, I believe.

> Then what is it there for?
>
> > What should be the blob fields segment size if I am planning to store
> files in the blob field.
> > Size maybe upto 3MB.
> >
> > I intend to use sub_type 0 since I dont know what type of files will be
> stored.
>
> The segment size has nothing to do with the size of a blob in general. Put
> it to whatever
> you like, or leave it as default.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com