Troubleshooting MySQL UTF encoded files cannot recover data: Let MySQL support emoji emoticons

Soft text link: http://blog.csdn.net/likendsl/article/details/7530979

http://blog.csdn.net/luwei42768/article/details/48732611

Show variables like ' character%

View Settings

Set character_set_client = UTF8MB4;  Set character_set_connection = UTF8MB4;  Set character_set_database = UTF8MB4;  Set character_set_results = UTF8MB4; Set character_set_server = UTF8MB4;

Restart MySQL

This article is from the "Flail Blog" blog, please be sure to keep this source http://jhomephper.blog.51cto.com/8558055/1763394

Troubleshooting MySQL UTF encoded files cannot recover data: Let MySQL support emoji emoticons