Skip to main content
added 3 characters in body
Source Link
Demerit
  • 24.7k
  • 2
  • 12
  • 34

I've never actually seen a utf8mb3 charset in the wild (it's the same as utf8 but it never calls itself utf8mb3). I would probably:

  • do a database backup
  • Run the api System.utf8conversion to convert to utf8mb4. If the database is large, run it via command line e.g. cv api3 System.utf8conversion, otherwise you can also run it in the UI via api3 explorer with Job=SystemEntity=System Action=utf8conversion

utf8mb4 is the default on new installs now and definitely recommended over utf8. And it usually fixes this "row too large" error but even if it doesn't you want to be using utf8mb4.

I've never actually seen a utf8mb3 charset in the wild (it's the same as utf8 but it never calls itself utf8mb3). I would probably:

  • do a database backup
  • Run the api System.utf8conversion to convert to utf8mb4. If the database is large, run it via command line e.g. cv api3 System.utf8conversion, otherwise you can also run it in the UI via api3 explorer with Job=System Action=utf8conversion

utf8mb4 is the default on new installs now and definitely recommended over utf8. And it usually fixes this "row too large" error but even if it doesn't you want to be using utf8mb4.

I've never actually seen a utf8mb3 charset in the wild (it's the same as utf8 but it never calls itself utf8mb3). I would probably:

  • do a database backup
  • Run the api System.utf8conversion to convert to utf8mb4. If the database is large, run it via command line e.g. cv api3 System.utf8conversion, otherwise you can also run it in the UI via api3 explorer with Entity=System Action=utf8conversion

utf8mb4 is the default on new installs now and definitely recommended over utf8. And it usually fixes this "row too large" error but even if it doesn't you want to be using utf8mb4.

Source Link
Demerit
  • 24.7k
  • 2
  • 12
  • 34

I've never actually seen a utf8mb3 charset in the wild (it's the same as utf8 but it never calls itself utf8mb3). I would probably:

  • do a database backup
  • Run the api System.utf8conversion to convert to utf8mb4. If the database is large, run it via command line e.g. cv api3 System.utf8conversion, otherwise you can also run it in the UI via api3 explorer with Job=System Action=utf8conversion

utf8mb4 is the default on new installs now and definitely recommended over utf8. And it usually fixes this "row too large" error but even if it doesn't you want to be using utf8mb4.