Sort problem, is it possible to downgrade / convert from utf8mb4_unicode_ci to utf8_general_ci?

Question

I work on the site locally, and after deploying it to my client server, I encountered an error

MySQL said: Documentation

'# 1273 - Unknown sort:' utf8mb4_unicode_ci '

After a lot of searching, I know that this is the version of MySQL, my local MySQL is 5.5, and the server is 5.1, which does not support utf8mb4_unicode_ci. Unfortunately, I can do nothing to upgrade the version of MySQL server.

So my question is: is there a way to convert my current database into something supported by MySQL 5.1?

Answer 1

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

This is compatible with utf8mb4 in that utf8 is a subset of utf8mb4 . Some Chinese characters, some emoticons, and some other things are missing in utf8 . Otherwise, the two encodings and sortings work the same way.

utf8mb4 was first added to version 5.5.3 in March 2010. Recommend updating.