My Oracle Support Banner

Convert Tables from Utf8mb3 to Utf8mb4 (Doc ID 2597735.1)

Last updated on NOVEMBER 05, 2019

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

When trying to migrate 5.7 to 8.0 the following warning appears

Warning: The following objects use the utf8mb3 character set. It is recommended to convert them to use utf8mb4 instead, for improved Unicode support.

More information: https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html

How could all those tables be changed?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.