I am running mysql 5.6.
Some columns in the schema that I inherited from previous developers have an explicit suggestion collate.
All explicitly quoted offers collatematch the default database collate.
Is there a way to remove explicit collatesentence columns ?
There should be no functional mappings of differences compared to the current collate, but I want the following:
to get sans column definitions collatewhen I query
create tablefrom mysql (I want to be able to compare table creation scripts from a code repository using create table
statements obtained from different schema instances to different mysql servers; explicit columns collateare only in some cases, but not in others, which will require me to use a more complex diff than regular text diff)
so that collatethese columns automatically change to whatever new default database is collateif I ever change it
1) much more important than 2), since I probably will never change again collate.
Thank.