Dealing with utf8mb4 warning error in dbForge Studio 2019 for MySQL

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Requnix
Posts: 23
Joined: Thu 12 Dec 2019 19:41

Dealing with utf8mb4 warning error in dbForge Studio 2019 for MySQL

Post by Requnix » Wed 15 Jan 2020 18:19

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.?

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Mon 10 Feb 2020 16:37

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.

Post Reply