Where can I change the default character set of a table in MySQL Workbench's data modeling tool?

Question

I created a database schema using MySQL Workbench's data modeling tool. When it generates the SQL CREATE statements, it generates "default character set = latin1;" for some tables, e.g.:

-- ----------------------------------------------------- -- Table `moocdb`.`resource_types` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `moocdb`.`resource_types` (   `resource_type_id` INT(11) NOT NULL,   `resource_type_name` VARCHAR(20) CHARACTER SET 'utf8' NOT NULL,   PRIMARY KEY (`resource_type_id`)) ENGINE = InnoDB default character set = latin1; 

How can I change it to the schema's default character set? (I found where to change the schema's default character set, but not the table's)

---

As a side note:

Note: Since MySQL 5.5.3 you should use utf8mb4 rather than utf8. They both refer to the UTF-8 encoding, but the older utf8 had a MySQL-specific limitation preventing use of characters numbered above 0xFFFD.

Answer 1

You can set the used charset/collation combination in the table editor. You have to expand the header (which is by default collapsed to save space) to be able to change it. See this screenshot:

Answer 2

Thanks a lot for this topic : it saves me a lot of time (I searched the header that was just collapsed by default).

I just want to say that you can specify for the table collation the option : schema default (the first option in the collation drop list).

And then, you can specify too the collation for the text type fields : table default.

With that, you can control the collation of your database with just the global schema collation parameter.

(my mysql workbench version : 6.1.7 revision 11891 build 1788)

Enjoy