MySQL Forums
Forum List  »  MySQL Workbench

MySQL Workbench 6.1.7 - missing collation when utf8mb4 character set is used
Posted by: Miha Svalina
Date: September 26, 2014 03:26AM

I'm using MySQL Workbench version 6.1.7.11891

When creating database (create statements) from model (Database -> Forward Enginner - Ctrl + G) MySQL Workbench does not add COLLATION for database when utf8mb4 character set and COLLATION utf8mb4_unicode_ci is used. For schema all it generates is:

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8mb4 ;

If I change database character set to utf8 and choose utf8_unicode_ci collation, it generates next lines:

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;



Just wanted to notice about this behaviour.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Workbench 6.1.7 - missing collation when utf8mb4 character set is used
2767
September 26, 2014 03:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.