Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

MySQL change BOOLEAN data type to BIT #56

Closed
hisystems opened this Issue Apr 23, 2012 · 0 comments

Comments

Projects
None yet
1 participant
Owner

hisystems commented Apr 23, 2012

Currently, a boolean field is defined as BOOLEAN which is an alias for TINYINT(1). However, MySQL version 5 now supports the BIT data type. This is important because using TINYINT will return a System.Int16 data value rather than a System.Boolean. This can then cause issues with a field marked with FieldMappingAttribute and of type System.Boolean because the data type cannot be implicitly converted from System.Int16 to System.Boolean.

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

@ghost ghost assigned hisystems Apr 23, 2012

@hisystems hisystems closed this in 78612df Apr 28, 2012

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment