MySQL Modify code (database, table, field)

• View individual encodings

  View field codes show full COLUMNS from Park_car_user;

  View database Fields
  SHOW CREATE DATABASE db_name;

  To view the encoding of a table
  SHOW CREATE TABLE tbl_name;

• Modify Database Encoding

[Client]  default-character-set=  GBK Port=3306 [Server]  default-character-set=  GBK Port=3306 [MySQL]  default-character-set=  GBK [mysqld]Port=3306Basedir=C:/Program Files/Mysql/Mysql/DataDir=C:/Program Files/Mysql/Mysql/Data/default-character-Set=GBKdefault-Storage-Engine=INNODB

• Modifying the encoding of a table

ALTER TABLE DEFAULT CHARACTER SET [COLLATE collation_name];

• Modify field Encoding

Modify the encoding of all fields in the table to UTF8

ALTER TABLE CONVERT  to CHARACTER SET UTF8;

MySQL Modify code (database, table, field)