MySQLErrorIncorrect string value: '\xE7\x81\xAB\xE7\x8B\x90...' for column 'tout' at row 1 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

##Attachment-- -Data types supported by MySQL

MySQL provides 8 basic string types, namely: CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, SET and other string types.

Can store data ranging from as simple as a single character to huge blocks of text or binary strings.

String type Byte size Description and storage requirements

CHAR 0-255 bytes Fixed-length string

VARCHAR 0-255 bytes Variable-length string

TINYBLOB 0-255 bytes Binary string of no more than 255 characters

TINYTEXT 0-255 bytes Short text string

BLOB 0-65535 bytes Binary form Long text data

TEXT 0-65535 bytes Long text data

MEDIUMBLOB 0-16 777 215-byte medium-length text data in binary form

MEDIUMTEXT 0-16 777 215 bytes medium length text data

LOGNGBLOB 0-4 294 967 295 bytes very large text data in binary form

LONGTEXT 0-4 294 967 295 bytes very large text data

VARBINARY(M) Allows fixed-length byte strings with a length of 0-M bytes, the length of the value + 1 byte

BINARY(M) M Allows a length of 0-M words Fixed-length byte string of section

美文美图

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)!