Write it down first, so that you won't be able to remember it again!
When using PHP to operate the database, the data in the database is UTF-8 encoded. when reading the data, all the information displayed is ??????? The question mark is garbled. I found some information and made a encoding setting before reading it:
CopyCodeThe Code is as follows: Create Table tablename
(
Id int not null auto_increment,
Title varchar (20) not null,
Contnet varchar (300) defalut null,
Primary Key ('id ')
) Begin = MyISAM default charset = utf8;
Run the following command before inserting data:Copy codeThe Code is as follows: mysql_query ("set names utf8 ");
Then
Mysql_query ("insert into tablename .....")
Run the following command before reading data:Copy codeThe Code is as follows: mysql_query ("set names utf8 ");
Then mysql_query ("select * From tablename ")
Note: The encoding read here is output after the original encoding content is re-encoded. For example, if the output content is located on the GBK encoding page, garbled characters are displayed on the page, therefore, execute mysql_query ("set names GBK") before the query to display the GBK-encoded text content on the page.