Is it possible to store binary data in a table in Baan ? Can text data type store binary data ? We are using Informix database,it has a datatype byte which we are using ober here to take a backup of an entire excel file. Can this be done in Baan ? We are using Baan 4c4 on Informix /Solaris .Thanks.

Baan also has data type byte . U can have any domain with byte data type associated with it .

Normally binary data type stores the true/false value . For this purpose u can use domain tcbool(which is byte data type) and store the value . Alternatively u can also use Enum domain tcyesno (which also is inrinsically byte ) to indicate similar behaviour .

Thanks for the reply.By binary i meant binary object data.In Informix there is data type byte used to store BLOB/CLOB which is large object.

Data type byte in Baan is used to store numbers like integer and maps to small int in Informix.

I understood wrongly by binary data. BLOB / CLOB did not occur to me . I have seen somewhere binary data type to indicate true/false values.

In Baan IV (don't know abt Baan V) BLOB / CLOB are not recognized . And text type field can not be used for that purpose.