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
• Status: Won't Fix
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.17
• OS: Windows
• CPU Architecture: x86
• Tags: charset, collation, workbench

[9 Aug 2019 7:47] Simon Vacker

Description:
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.

regards,
Umesh

[14 Sep 18:05] Omer Barnir

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.