When I import my MS Access DB to Navicat, why are all my yes/no fields imported as tinyint?

Apply OS: Windows, Mac

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All

MySQL database does not have Boolean field type. Therefore, Navicat couldn't convert yes/no field into MySQL database.

During Import process, the value of yes/no field in Access DB will be converted to the value (1, 0) in MySQL database. It's because Access DB use (1, 0) for yes/no field.

Have more questions? Submit Ticket.
Have more questions? Submit a request


Article is closed for comments.