| Subject | RE: [firebird-support] Where are the boolean fields? |
|---|---|
| Author | George P Boutwell |
| Post date | 2003-10-08T13:38:26Z |
InterBase 7.1 added the BOOLEAN datatype. I don't know about Firebird.
They typical workaround for InterBase and Firebird in the past has been
to create a domain.
i.e., CREATE DOMAIN MY_BOOLEAN INTEGER DEFAULT 0 CHECK IN (0,1)
You probably to avoid head-aches if an BOOLEAN does exist or is added,
don't want to name your domain BOOLEAN.
George
-----Original Message-----
In databases like Paradox or MSAccess, there are fields wich data
type is the boolean type. I didnĀ“t find it in Firebird/Interbase. Where
are they? Do they exist? If not, what are the alternatives?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 10/6/2003
They typical workaround for InterBase and Firebird in the past has been
to create a domain.
i.e., CREATE DOMAIN MY_BOOLEAN INTEGER DEFAULT 0 CHECK IN (0,1)
You probably to avoid head-aches if an BOOLEAN does exist or is added,
don't want to name your domain BOOLEAN.
George
-----Original Message-----
In databases like Paradox or MSAccess, there are fields wich data
type is the boolean type. I didnĀ“t find it in Firebird/Interbase. Where
are they? Do they exist? If not, what are the alternatives?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 10/6/2003