Data Modeler translate booleans

I made a similar experience when usiing the Data Modeler with my MySQL database which uses tinyint(1) as a Boolean field (somebody used Access to alter the table structure and Access stores Booleans that way - MySQL itself doesn't have a Boolean field type). This can be easily modified in the TMS Aurelius Export Dialog. Simply switch to the Mappings Tab and change the Mapping to the desired Property Type for the field in the table. That will generate the unit file properly without the need to manually convert the field types in the unit file. The Mappings are stored in the project.

1 Like