Bug #96481 MySQL Workbench 8.0 shows wrong collation/charset for MySQL 5.6 tables
Submitted: 9 Aug 2019 7:47 Modified: 9 Aug 2019 10:21
Reporter: Simon Vacker Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.17 OS:Windows
Assigned to: CPU Architecture:x86
Tags: charset, collation, workbench

[9 Aug 2019 7:47] Simon Vacker
When using MySQL Workbench 8.0.17 and I choose "Alter table" on a table on our MySQL 5.6.42 server, it doesn't show the correct collation/charset in the dropdowns. It shows the correct collation under "Table inspector", which I assume is taken directly from information_schema. When using Workbench 5.6 everything is as it should.

Tables with utf8_swedish_ci show in the dropdowns as utf8 (1st dropdown) utf8_bin (2nd dropdown).
Tables with utf8mb4_swedish_ci show as utf8mb4 utf8mb4_0900_ai_ci.

How to repeat:
Create a database and table on a MySQL 5.6 server with the collation utf8_swedish_ci and another table with utf8mb4_swedish_ci. Then select "Alter table" using MySQL Workbench 8.0.
[9 Aug 2019 10:21] MySQL Verification Team
Hello Simon Vacker,

Thank you for the report and feedback.
Observed this on Win10 with WB 8.0.17/MySQL Server 5.6.45.