Jump to content

Converting Database to UTF8MB4


Black Six

Recommended Posts

I have a recommendation in my ACP saying the following:

Quote
Your database is currently configured to use single-byte UTF-8 Encoding. Some non-common symbols (such as historical scripts, music symbols and Emoji) require 4-Byte UTF-8 Encoding. If you want users to be able to post these symbols, your database needs to be converted.

Based on my past experience, running these sorts of SQL updates through the ACP almost always times out and ends up incomplete. Is there a way to get the SQL commands needed to do this conversion so I can do it via SSH or PHPMyAdmin?

Thanks!

Link to comment
Share on other sites

49 minutes ago, Black Six said:

I have a recommendation in my ACP saying the following:

Based on my past experience, running these sorts of SQL updates through the ACP almost always times out and ends up incomplete. Is there a way to get the SQL commands needed to do this conversion so I can do it via SSH or PHPMyAdmin?

Thanks!

It's designed to be ran in this environment; it doesn't run all queries at once.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...