Bug #68672 cannot apply changed collation

• Submitted: 14 Mar 2013 10:48
• Modified: 16 Jan 2014 18:58
• Reporter: Marcin Szalowicz
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.47
• OS: Linux (Ubuntu 12.04/amd64)
• CPU Architecture: Any

[14 Mar 2013 10:48] Marcin Szalowicz

Description:
Sometimes when changing field collation, i cannot apply changes, cause wb is giving me information: "No changes detected"

How to repeat:
CREATE TABLE `test_tbl` (
  `field` varchar(45) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
open table editor
change column collation to: utf8_polish_ci

[14 Mar 2013 15:05] MySQL Verification Team

Thank you for the bug report.

[11 Dec 2013 20:25] Armando Lopez Valencia

Posted by developer:
 
NOT Fixed
Verified in:
Windows 8x64
WB 6.1.0.11482

Any "utf8.*" option selected is not detected by WB (see attachment).

[18 Dec 2013 15:02] Marcin Szalowicz

bug #70154 is a duplicate of this one

[9 Jan 2014 15:33] Armando Lopez Valencia

Posted by developer:
 
NOT FIXED
Verified in:
Windows 7x64
Ubuntu 13.10x86
WB 6.0.9.11410
WB 6.1.1.11555
WB still do not detect changes when you change the COLUMN collation.

[16 Jan 2014 18:58] Philip Olson

Fixed as of the upcoming Workbench 6.1.1 release, and here is the changelog entry:

Changing the collation type would not always be detected, as "No changes
detected" would be reported after attempting to apply the change.

Thank you for the bug report.

[16 Feb 2018 15:25] Jonathan Shaltz

I'm still getting this in 6.3.  FWIW, it lets me change the collation of the table, but that does not change the collation of the individual fields.  If I try to change the collation of a specific field, it reports "No changes detected" and does not update the collation.

[2 Dec 2019 11:00] Gerrit Addiks

Please re-open this Ticket. 

I am on MySQL-Workbench 6.3.10 (Ubuntu 16.04) and still have this issue.