MySQL Forums
Forum List  »  MySQL Workbench

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.

Options: ReplyQuote


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.