I am running mysql 5.6.
Some of the columns in a schema that I inherited from previous developers have an explicitly specified collate
clause.
All explicitly specified collate
clauses are the same as the database's default collate
.
Is there any way to remove the explicit column collate
clauses?
There should be no functional collating differences versus my current collate
, but I want the following:
to get column definitions sans
collate
clauses when I request acreate table
statement from mysql (I want to be able to compare table creation scripts from a code repository withcreate table
statements obtained from different instances of the schema on different mysql servers; the explicit columncollate
clauses are only in some instances, but not others, which would require me to use a more complex diff than a plain text diff)to have the
collate
of these columns automatically change to whatever is the new default databasecollate
if I ever change it
1) is much more important than 2), however, since I will probably never change the collate
again.
Thanks.