Modify the mysql table encoding when php is garbled

Today, I installed a zen-cart friendship link plug-in. the plug-in for Chinese websites is not easy to use. if you want to find it, go to the English website to download the latest version. It is better to use English. When importing a table, pay attention to the table encoding. if the default mysql encoding is not utf8, garbled characters may occur... SyntaxHighlighter. all ();

Today, I installed a zen-cart friendship link plug-in. the plug-in for Chinese websites is not easy to use. if you want to find it, go to the English website to download the latest version.
It is better to use English.

When importing a table, pay attention to the table encoding. if the default mysql encoding is not utf8, garbled characters may occur. When I was using the plug-in, I encountered garbled characters after the Chinese link of the plug-in.

The following describes how to modify the encoding.
1. export data and table structures respectively.
2. modify charset = gbk or charset gbk in the table structure to charset = utf8 or charset utf8 (replace the encoding part with the editor in batches)
3. import the table structure.
4. import data.

In this case, OK.

Author: youaregoo