With Navicat for MySQL has built a database, and set the character set to utf8, then import CSV file in Chinese, according to the Data too long for the column 'url' at row 1, according to the online solution changed my. The default character set in the ini file, etc., and the SQL - mode="STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION" comment out this sentence, or modified to SQL - mode="NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTION", had tried findings show that the import is successful, but only import a Data, and the Data behind a few columns or blank, do you know is what reason, and how to solve

CodePudding user response:

Should be the problem of character set

CodePudding user response:

A: if the url type is varchar, set point long;
2: if the url is bad to estimate how long the length, the text to type

CodePudding user response:

What is your table structure is first, the second into not, what is the length of each field,
There is a problem hint, mysql utf8 is 3 bytes, had better use utf8 utf8mb4 this is generalized