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?
294
December 05, 2019 01:57PM


Sorry, only registered users may post in this forum.

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.