Bug #71938 ALTER TABLE..CONVER TO changes collation from cs to ci w/o warning.
Submitted: 5 Mar 2014 12:24
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
Category:MySQL Server: Charsets Severity:S4 (Feature request)
Version:5.6.16 OS:Any
Assigned to: CPU Architecture:Any

[5 Mar 2014 12:24] Daniël van Eeden
The ALTER TABLE..CONVERT TO CHARACTER SET.. command can be used to change the character set.

However it also modifies the collation. If no collation is specified it will use the default collation for the character set.

It would be helpful if mysql would give an error if one or more columns are changed from a case sensitive to a case insensitive character set.

How to repeat:
See description