How can I change the default charset globally?
Posted by:
Ric Ric
Date: December 05, 2019 01:57PM
Hello,
I am using MySQL Workbench for Mac, version 8.0.18.
My database uses AWS Aurora and uses utf8mb4 (because I want emojis)
However, when I press "Synchronize Model with Database", the script has
ALTER SCHEMA `mydb` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
And
DEFAULT CHARACTER SET = utf8;
for every single table.
I know that I can change that manually for every single table, but that is very annoying.
How can I change that so the entire model uses utf8mb4? I don't see anything in the menus or preferences.
Thanks a lot.
Subject
Views
Written By
Posted
How can I change the default charset globally?
1836
December 05, 2019 01:57PM
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.