MySQL not support international characters

Moving a site from one server to another could be a pain.

Source server:
MySQL version = 5.6.36-82.1-log
charset: utf8mb4

Target server:
MySQL version = 5.1.51-community
charset: utf8

The target server mysql does not support charset utf8mb4, so remove it, and import the script.

All Chinese words are changed to quotation marks ??.

 

Solution:

change script:

/*!40101 SET NAMES utf8 */;
DEFAULT CHARSET=utf8

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *