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 ??.



change script:

/*!40101 SET NAMES utf8 */;



 355 total views

Author: Albert

Leave a Reply