Home >Database >Mysql Tutorial >mysql advanced (twenty-two) MySQL error Incorrect string value: '\xE7\x81\xAB\xE7\x8B\x90...Chinese character input error
During the experiment, the output parameters need to be written to the database. During the writing process, an error occurred when executing the lab_dynamic_order.upd_upd() statement. I didn’t understand at first what it was. Something went wrong. I tried to ask Du Niang for help. Some people on the Internet said it was because of the input of Chinese characters. Therefore, I copied the string containing Chinese characters to be written into mysql. When saving, Incorrect string value: '\xE7\x81\xAB\xE7\x8B\x90...' for column 'tout appeared. ' at row 1 error message. After another search, the solution is as follows:
Change the corresponding column to utf8-utf8_general_ci.
The processed results are as follows
The above is the content of mysql advanced (22) MySQL error: Incorrect string value: '\xE7\x81\xAB\xE7\x8B\x90...Chinese character input error. For more related content, please pay attention to the PHP Chinese website ( www.php.cn)!