navicat 1366 error

Navicat sometimes reports an error when creating a table. warning(s): 1366 Incorrect string value: '\xE8\x82\x96\xE5\xB1\xB1...' for column 'sub_station_name'. Below I will introduce the solution in detail to you.

Recommended tutorial:MySQL introductory video tutorial

##Solution:

1. The database schema character set is set to utf-8

2. The table character set is set to utf-8

3. The Chinese column character set is set to utf -8

　4. CharsetEncode=utf8

has been specified in the connection url. Step 4 is very critical.

Remarks:

1. Look at the database character set

show create database test;

Note: test is the database name.

　2. Look at the data table character set

show create table t_data;

Note: t_data is the table name.

The above is the detailed content of navicat 1366 error. For more information, please follow other related articles on the PHP Chinese website!