Subject Re: [firebird-support] What BLOB to use for RTF data
Author Helen Borrie
At 10:31 AM 12/10/2004 +0530, you wrote:

>Hi all
>What sub-type of BLOB is to be used for RTF data. I have tried 0, 1 and 2
>sub-types but was not lucky in my VFP6 application. I have successfully
>tried the same on VFP table using Memo (Binary) so implementing it using FB
>I guess should be easy.

Fb doesn't care - all blobs are binary as far as the engine is
concerned. However, there's an inbuilt filter that lets sub_type 1 (or
sub_type text, if you prefer) be output in a byte-encoding that receiving
applications recognise as characters.

You could store RTF as sub_type 0 or 1. (Sub_type 2 is an internal filter,
I think it stores BLR). Your application has to know what to do with it,
of course. It doesn't magically pop up somewhere as pretty text. People
normally pass RTF data into an RTF editor.