-
-
Notifications
You must be signed in to change notification settings - Fork 563
Can't set BOOLEAN type for column (MySQL 8.*) #1541
Copy link
Copy link
Closed
Labels
featureA new feature to implementA new feature to implementnettype-mysqlMySQL and/or MariaDB specific issueMySQL and/or MariaDB specific issue
Milestone
Description
Preconditions
- HeidiSQL version: 11.3.0.6415
- Database type and version: MySQL 8.0
- OS: Windows 10
Describe the bug
Can't set BOOLEAN type for table column.
P.S. Why I'm don't use TINYINT? Mysql convert BOOLEAN type to TINYINT(1), not to TINYINT(3). My code to generate form by table and checks length of TINYINT columns: TINYINT(1) - <input type="checkbox">, TINYINT(3) - <input type="number">.
To Reproduce
Add new table column and check type list
Screenshots or Crash reports
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
featureA new feature to implementA new feature to implementnettype-mysqlMySQL and/or MariaDB specific issueMySQL and/or MariaDB specific issue