How to solve the problem of MySQL query character set mismatch

Find the problem

I recently encountered a problem at work. When creating a table in MySQL database, latin character set was used, while utf-8 was used for querying on the web page. When Chinese characters were entered on the input page and then queried in the database, ER_CANT_AGGREGATE_2COLLATIONS: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and （utf8_general_ci,COERCIBLE) for operation '=' .

SET collation_connection = 'utf8_general_ci'

Note: Replace the following two sentences with your database name and your data table name

ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci 
 
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

This ensures that the database is also in the UTF-8 character set, so there will be no errors when querying the contents of the database when Chinese is input.

reference: Illegal mix of collations MySQL Error

Set the database character set to utf-8 in PHP

mysqli_set_charset($dbc,'utf8');

Just add meta to display utf-8 in HTML

<meta charset="utf-8">

Summarize

Well, the above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.