How do I change to UTF-8?

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

  • I am creating a database schema using the 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)

  • Answer:

    http://stackoverflow.com/a/18975526/395857: Expand the header (which is by default collapsed to save space) to be able to change it:

Franck Dernoncourt at Quora Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.