Using the Standard InterBase Text Filters
From InterBase
Go Up to Filtering Blob Data (Embedded SQL Guide)
The standard InterBase filters convert Blob data of sub-type 0, or any InterBase system type, to sub-type 1 (TEXT).
When a text filter is being used to read data from a Blob column, it modifies the standard InterBase behavior for supplying segments. Regardless of the actual nature of the segments in the Blob column, the text filter enforces the rule that segments must end with a newline character (\n).
The text filter returns all the characters up to and including the first newline as the first segment, the next characters up to and including the second newline as the second segment, and so on.
Tip:
To convert any non-text sub-type to
To convert any non-text sub-type to
TEXT, declare its FROM sub-type as sub-type 0 and its TO sub-type as sub-type 1.