after I connected to mysql with cmd, I created the table and inserted the data, but the Chinese displayed was garbled. After
, I changed the encoding to the data in the gbk,gender column and there was a problem.
mysqlutf8.
Navicatmysql
after I connected to mysql with cmd, I created the table and inserted the data, but the Chinese displayed was garbled. After
, I changed the encoding to the data in the gbk,gender column and there was a problem.
mysqlutf8.
Navicatmysql
you need to set the database to utf8 encoding, and the data table is also utf8 encoding to re-insert Chinese data. Navicat Premium is just a tool that links MySQL to display the queried data. The software itself does not do any coding operation, so you do not need to set up the software deliberately, just set the encoding mode of the database and data table, and re-insert Chinese data!
Navicat is connected to the database of the real server and has all the permissions to add, delete, modify and check. First ask the bosses if there is any way not to change the permissions of users in the database on the server side, but to limit their p...
