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
Related Q & A:
- How can I change my "default" email program to Yahoo?Best solution by Yahoo! Answers
- Where can i find good default layouts?Best solution by Yahoo! Answers
- How can I change the default Windows Mail?Best solution by Yahoo! Answers
- Where can I change the name that appears in from in yahoo mail?Best solution by Yahoo! Answers
- Can I change my default font for all emails on Yahoo Classic?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.