排序规则问题，是否可以从utf8mb4_unicode_ci降级/转换为utf8_general_ci? [英] Collation issue, Is it possible to downgrade/convert from utf8mb4_unicode_ci to utf8_general_ci?

问题描述

我一直在本地站点上工作，并且在部署到客户端服务器时遇到了错误

I've been working on a site locally and upon deployment to my client's server I came across the error

MySQL表示:文档

MySQL said: Documentation

'#1273-未知归类:'utf8mb4_unicode_ci'

'#1273 - Unknown collation: 'utf8mb4_unicode_ci'

经过大量的挖掘，我知道这与MySQL版本有关，我的本地MySQL是5.5，而服务器是5.1，它不支持utf8mb4_unicode_ci.不幸的是，我无法升级服务器的MySQL版本.

After a lot of digging I know this is MySQL version related, my local MySQL is 5.5 while the server is 5.1 which does not support utf8mb4_unicode_ci. Unfortunately, there's nothing I can do to upgrade the server's MySQL version.

所以我的问题是，我是否仍可以将当前数据库转换为MySQL 5.1支持的内容?

So my question is, is there anyway I can convert my current database down to something MySQL 5.1 would support?

推荐答案

同时"，5.1版具有CHARACTER SET utf8 COLLATE utf8_unicode_ci.

"Meanwhile", 5.1 has CHARACTER SET utf8 COLLATE utf8_unicode_ci.

这与utf8mb4兼容，因为utf8是utf8mb4的子集. utf8中缺少一些汉字，一些表情符号和其他一些东西.否则，两个字符集和排序规则将完全相同.

This is compatible with utf8mb4 in that utf8 is a subset of utf8mb4. Some Chinese characters, some emoticons, and some other stuff are missing from utf8. Otherwise the two charsets and collations work identically.

utf8mb4最初于2010年3月添加到5.5.3版.建议升级.

utf8mb4 was first added to Version 5.5.3 in March, 2010. Recommend you upgrade.

这篇关于排序规则问题，是否可以从utf8mb4_unicode_ci降级/转换为utf8_general_ci?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！