Home/ Questions/Is it okay to fix the utf8mb4_unicode_520_ci problem?
Next
Answered
Hunter Thomas
  • 29
Asked: 2022-05-18T20:31:25+00:00 In:

Is it okay to fix the utf8mb4_unicode_520_ci problem?

  • 29

. Advertisement .

..3..

. Advertisement .

..4..

I get the “utf8mb4_unicode_520_ci” issue when trying to upload the database of a WordPress website to the live server. Here is the detail of the error I got the error message:

Uncaught TypeError: Cannot read property '0' of undefined

Please give me some advice to solve this problem.

utf8mb4 unicode 520 ci
Share

2 Answers

  1. Best Answer
    Expert

    The cause:

    You have got the ”utf8mb4_unicode_520_ci” problem because the versions of MySQL in the live server and local server are totally different.

    Solution:

    You can handle this issue by looking for:

    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

    Then, let’s convert it into the following command in your .sql file:

    ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

    Your problem will be solved effectively by this way.

    • 0

  2. This error could be caused by MySQL versions being different on the live and local servers. This is how to fix it:

    1. In your text editor, open the sql file
    2. Replace all utf8mb4_unicode_520_ci codes with utf8mb4_unicode_ci
    3. Save and upload to a new mySql database

    We hope that helpsutf8mb4_unicode_520_ci brings you joy.

    • 20

Leave an answer

You must login to add an answer.

Need An Account,