In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, MySQL for Excel has always let you create new schemas and tables in a MySQL database, in versions lower than 1.3.0 these were created with the default character set and collation defined in the MySQL server. Starting with version 1.3.0 we introduced several features regarding collations:
- New drop-downs were added that let you to override the default collation for new MySQL schemas and tables.
- Default collations for each schema can be shownin the schemas list below the schema names.
- The SQL queries for schemas creation can be previewed or displayed (depending on its global setting).
Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.