MySQL: TINYINT(1) values are displayed as true/false instead of number Print

This behaviour is due to the MySQL database driver that handles tinyint(1) as bit by default.

To change this, open the connection, navigate to the Properties tab and select Driver Properties. Locate the tinyInt1isBit parameter and change its value to false. Apply the changes and reconnect.

For reference, see MySQL Connector documentation: https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html