Mysql modifying character set statements

Modify the database character set: [SQL] 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: [SQL] 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: www.2cto.com [SQL] 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: [SQL] 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 DATABASE encoding: [SQL] SHOW CREATE DATABASE db_name; view TABLE encoding: [SQL] show create table tbl_name; view field encoding: [SQL] SHOW FULL COLUMNS FROM tbl_name; www.2cto.com restart Mysql service in Windows after modifying the character set: start-> Run-> cmd stop: net stop mysql start: net start mysql prerequisites MYSQL has been installed as a windows service Linux: 1. startup method 1. start with service: service mysqld start2, start with mysqld Script:/etc/inint. d/mysqld start3. Start with safe_mysqld: safe_mysqld & 2. Stop www.2cto.com 1. Start with service: service mysqld stop2. Start with mysqld Script:/etc/inint. d/mysqld stop3, mysqladmin shutdown 3, restart 1, start with service: service mysqld restart2, start with mysqld Script:/etc/inint. d/mysqld restart author huxiweng