php - Collation issue, Is it possible to downgrade/convert from utf8mb4_unicode_ci to utf8_general_ci? -


i've been working on site locally , upon deployment client's server came across error

mysql said: documentation

'#1273 - unknown collation: 'utf8mb4_unicode_ci'

mysql error

after lot of digging know mysql version related, local mysql 5.5 while server 5.1 not support utf8mb4_unicode_ci. unfortunately, there's nothing can upgrade server's mysql version.

so question is, there anyway can convert current database down mysql 5.1 support?

"meanwhile", 5.1 has character set utf8 collate utf8_unicode_ci.

this compatible utf8mb4 in utf8 subset of utf8mb4. chinese characters, emoticons, , other stuff missing utf8. otherwise 2 charsets , collations work identically.

utf8mb4 first added version 5.5.3 in march, 2010. recommend upgrade.


-