Home > Database > navicat > navicat 1366 error

navicat 1366 error

angryTom
Release: 2019-08-07 15:00:22
Original
7317 people have browsed it

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;
Copy after login

Note: test is the database name.

 2. Look at the data table character set

show create table t_data;
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template