Description:
After creating a table with "CHARSET=utf8mb4 COLLATE=utf8mb4_bin", opening "Alter Table" shows "Charset/Collation: utf8mb4 utf8mb4_0900_ai_ci", rather than the expected collation of "utf8mb4_bin".
The collation utf8mb4_0900_ai_ci being first in the drop down list may point to a problem with not activating the correct value on screen render.
How to repeat:
CREATE SCHEMA `testschema` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ;
CREATE TABLE `testschema`.`testtable` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`testname` VARCHAR(45) NULL,
PRIMARY KEY (`id`));
; confirm inherited charset and collation
SHOW CREATE TABLE testschema.testtable;
| testtable | CREATE TABLE `testtable` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testname` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
Open testschema.testtable in MySQL Workbench Alter Table, see "Charset/Collation: utf8mb4 utf8mb4_0900_ai_ci".
Suggested fix:
Alter table should correctly show the defined charset and collation.