Why do my 'yes/no' fields get converted to tinyint when I import my MS Access database into Navicat?
updated at
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium
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?
-
Support
-
About Us