Bit values when using the perl XML::XMLtoDBMS package
For a project I am working on, we are using Ronald Bourret’s XML-DBMS package. We used it successfully on a different project and did not expect any issues. However, our source (MySQL) database on the new project contains columns of type
bit(1). The generated XML file contained empty tags for columns containing bit values.
Turns out that the solution is similar to the solution for selecting bit values found in the MySQL 5.1 reference manual. In your mapping file, for the column definition, all you need to do is add a "+0" to the column name. Like this:
<Column Name="columnName+0"/>. Now, the bit values export as you would expect.