Subject Re: [firebird-support] Blob Fields
Author Martijn Tonies
Hi Mike,

> Can anyone point to documentation which defines the Sub Types and
> Segment size of Blob Fields. Im want to aschieve the following :

Firebird itself doesn't really care about subtypes, you can store
what you like. There are some buildin subtypes with build in filters
for retrieval, but that's it.

The usual subtypes used are:
0 - binary (store anything)
1 - text (plain text or similiar)

You can use negative subtypes (-1 etc) as "user defined" subtypes. Next,
you can define filters that use your blob and automagically convert it.
This, however, cannot be used in plain DSQL, so I wouldn't bother.

Segment size is used when you retrieve blobs in segments - most people
never care about this and it works fine ;-) ...

> 1. Store RTF data in a Firebird Table. With a Blob Field, whast
> should I set the Sub Type and Segment Size to.

> 2. Storing Fast Report Reports in a BLOB field using the SaveToBlob
> Field method.

Blib subtype 0.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions