Bit values when using the perl XML::XMLtoDBMS package

May 21, 2011 by mensming.

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.

Posted in perl | 1 Comment »