MYSQL equivilant for MSSQL Bit datatype
Posted on 2008-06-13
In my MSSQL a boolean field is a bit datatype
Havign done a migration of a MSSQL database into MySQL all my Bit values have been converted to TinyInt(4) value that dont accept a bool variables value in an insert statement.
Looking at MySQL datatypes I note that there are Bit, TinyInty(1) and Boolean datatypes....(When I select Boolean and apply the changes to the table it changes the value to TinyInt(1))
Is Boolean the correct type to use for a boolean value (true, false) in MySQL...is Bit interchangable with Boolean? What is teh correct datatype to use in MySQL if i am trying to store Boolean data values.