MySQL Bugs: #71938: ALTER TABLE..CONVER TO changes collation from cs to ci w/o warning.

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:	None
Category:	MySQL Server: Charsets	Severity:	S4 (Feature request)
Version:	5.6.16	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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