MySQL modifies character sets

Modify the database character set:

ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];

Change the default character set and all character columns (char, varchar, text) of the table to the new character set:

Alter table tbl_name convert to Character Set character_name [collate...] For example: alter table logtest convert to Character Set utf8 collate utf8_general_ci;

Only modify the default Character Set of the table:

Alter table tbl_name default Character Set character_name [collate...]; for example: alter table logtest default Character Set utf8 collate utf8_general_ci;

Modify the character set of a field:

Alter table tbl_name change c_name Character Set character_name [collate...]; for example: alter table logtest change Title varchar (100) Character Set utf8 collate utf8_general_ci;

View the database code:

SHOW CREATE DATABASE db_name;

View the table encoding:

SHOW CREATE TABLE tbl_name;

View the field encoding:

SHOW FULL COLUMNS FROM tbl_name;

After modifying the character set, restart the MySQL service:

Windows:

Start> RUN> cmd
Stop: net stop MySQL
Start: Net start MySQL
If MySQL is installed as a Windows service

In Linux:

I. Startup Mode

1. Start with service: Service mysqld start

2. Use the mysqld script to start:/etc/inint. d/mysqld start

3. Start with safe_mysqld: safe_mysqld &

Ii. Stop

1. Start with service: Service mysqld stop

2. Use the mysqld script to start:/etc/inint. d/mysqld stop

3. mysqladmin Shutdown

3. Restart

1. Start with service: Service mysqld restart

2. Use the mysqld script to start:/etc/inint. d/mysqld restart