da-soft - Data Access Technologies

Additional

Topic: bit in firebird/odbc ?

sally
User

Junior Boarder

Posts: 18

Karma: 0

bit in firebird/odbc ?

Posted: 2007/06/02 22:21

I am using firebird via ODBC.

since firebird don't have bit field (as in MSSQL), what field do I use as equivalent for bit in Firebird?

Diman

Admin

Posts: 1496

Karma: 19

Re:bit in firebird/odbc ?

Posted: 2007/06/03 02:12

Hello

Firebird, AFAIK, does not have bit/boolean data types. But you can create domain in FB database, like that:


 CREATE DOMAIN MyBit AS
SMALLINT
CHECK (VALUE IN (0,1))

And use it as bit/boolean data type.

Regards,
Dmitry