Hi,

> 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