Home >Backend Development >PHP Tutorial >mysql5.1导入mysql5.5数据库, 报#1115-unknown character set:‘utf8mb4’

mysql5.1导入mysql5.5数据库, 报#1115-unknown character set:‘utf8mb4’

WBOY
WBOYOriginal
2016-06-06 20:22:311970browse

我的mysql5.5数据库导入到一个5.1的mysql,报错:

<code>#1115-unknown character set:‘utf8mb4’</code>

回复内容:

我的mysql5.5数据库导入到一个5.1的mysql,报错:

<code>#1115-unknown character set:‘utf8mb4’</code>

如果我没有记错的话,mysql5.5才有的utf8mb4字符集的,所以向下导入会导致字符集无法识别

你的数据库的字符集里有utf8mb4,这个字符集在5.5里是支持的,但是5.1里是不支持的。你把sql文件里的所有utf8mb4替换成utf8就好了。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn