cfwheels-dbmigrate-plugin icon indicating copy to clipboard operation
cfwheels-dbmigrate-plugin copied to clipboard

Published 20 hours ago • verified publisher icon tdm00

MySQL adapter boolean type should be BIT, not TINYINT

Open andybellenie opened this issue 12 years ago • 1 comments

Change the adapter code for MySQL to:

<cfset variables.sqlTypes['boolean'] = {name='BIT'}>

andybellenie avatar Aug 14 '12 14:08 andybellenie

I agree, the current implementation fo TINYINT(1) appears similar to BIT because of the view, but it's actually still stored as a tinyint datatype. My open fork/pull request has a fix for this.

jordanclark avatar Apr 02 '13 15:04 jordanclark