Changes in Adobe ColdFusion 8.0.1 behavior with mySQL 5.x tinyint(1) column types cause null values to be returned as zero. Previous versions of ColdFusion would return this null value as "[empty string]". The previous behavior of returning these null values as an empty string can be restored using the connectstring argument tinyInt1isBit, as described below.
The workaround requires that you install an updated neo-drivers.xml file and update all MySQL 5 datasources with the connectstring parameter tinyInt1isBit set to false.
The argument is added by clicking the advanced settings button in the mySQL datasource page. The argument is case-sensitive. Multiple connectstring arguments are separated by ampersands (&) in mySQL datasources.
Keywords:
kb403748
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.
