Home > Net >  How to solve: MySQL5.7.27 modified coding format for utf8, why still can't insert into the data
How to solve: MySQL5.7.27 modified coding format for utf8, why still can't insert into the data

Time:10-10

A, I MySQL5.7.27 database version is as follows:



Second, database defines the three fields, see below:
Id, name and map,
Id and the name of varchar type fields,


Three, according to the online method, will be C: \ ProgramData \ MySQL \ MySQL Server 5.7 \ my ini according to below change



Four, restart computer
5, check the modified code format
Can observe all coding are amended as utf8


All five, the database record delete all
Six, run a c # program to empty the database insert new records, the records contained in the [Chinese]
But contains the record of Chinese information still can't insert in the database,
note: can insert the success, as long as he doesn't contain Chinese information contains the Chinese information is inserted into the failure [color=# FF0000] [/color]

to ask: what is the reason!

CodePudding user response:

I'm coding format of the data table is also modified to UTF8, empty database, and then restart the computer,


Run the c # program, is still as long as can't insert is containing the record of Chinese information database,

Excuse me: what's the reason?

  •  Tags:  
  • C #
  • Related