On 10/12/2011 07:39 pm, Mark Rotteveel wrote:

>
> 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
>

Thanks Mark.

I tried that too, but no joy. Seems there is something else that I
might be missing on their front. As I have tried Blob 0, Blob 1,
Char(8000), VarChar(8000) the last two w/ and w/o OCTETS.

Thanks again

Kind regards
Bhavbhuti