DataMgr 2.1 Documentation: Exceptions

Exceptions

Although DataMgr allows you to write code that will run the same across multiple CFML engines and databases, it does have a few exceptions of which you should be aware.

MS Access

DataMgr cannot introspect the database unless read permissions are enabled in Access on system tables. Active Schema should still work though.

MySQL

As MySQL doesn't have a data type specifically for boolean data, DataMgr follow the convention of using the "tinyint" data type for this purpose. As a consequence, DataMgr will not store numeric data in this field - instead limiting values to 1 and 0.