Subject Re: [IB-Conversions] IB Fields
Author Helen Borrie
At 02:19 PM 08-04-02 +0000, you wrote:
>Hi All.
>
>I am trying to create a Interbase Table but I don't know what the
>interbase field is for a Boolean Field.

InterBase doesn't have a Boolean type - you define your own using a
domain. It can be whatever you like but most people use either a
VARCHAR(1), some variation on 'T' and 'F' or a smallint with 0 and 1, using
CHECK constraints to force them to be one of the two chosen values.


>Could someone please post a list of all the field types for Interbase.
>
>i.e. varchar, Integer, etc...

Get hold of the InterBase 6 documentation and read the Data Definition
guide and the Language Reference. Here is a link:

ftp://ftpc.inprise.com/pub/interbase/techpubs/ib_b60_doc.zip

regards,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________