Subject Re: [firebird-support] Is BLOB a binary field?
Author Mark Rotteveel
On 10-12-2011 12:33, venussoftop wrote:
> Hi all
>
> I need to create a fields that will hold about 200KB or more of data. This field is expected to be a Binary field as per their online document here http://reportman.sourceforge.net/doc/externalsec.html (see "A field where the report will be stored (must be of binary type)")
>
> I tried to provide a BLOB SUB_TYPE 0 (I can't seem to create any other SUB_TYPE other than 0). I also tried VarChar and Char fields but it keeps on complaining.

BLOB or BLOB SUB_TYPE 0 is a binary datatype, BLOB SUB_TYPE 1 is a text
type (aka CLOB). You could also try to use VARCHAR CHARACTER SET OCTETS

Mark
--
Mark Rotteveel