Page 1 of 1

Dealing with utf8mb4 warning error in dbForge Studio 2019 for MySQL

Posted: Wed 15 Jan 2020 18:19
by Requnix
Now that I am processing all warnings accordingly, I am curious why dbForge has defaulted the creation of my database to utf8 vs. utf8mb4.

Is there an easy way with dbForge Studio to convert my database tables and structure all to utf8mb4? Everything I've seen online is this has to be done manually, and it's a long, grueling process.

And how can I default to utf8mb4 for the creation of future tables, etc.?

Re: Dealing with utf8mb4 warning error in dbForge Studio 2019 for MySQL

Posted: Mon 10 Feb 2020 16:37
by alexa
Is there an easy way with dbForge Studio to convert my database tables and structure all to utf8mb4? Everything I've seen online is this has to be done manually, and it's a long, grueling process.
This should be done manually for each column. You can open a table with the Table Editor of dbForge and change it for each column.
And how can I default to utf8mb4 for the creation of future tables, etc.?
This is the the setting of the server itself.