查看 DB 編碼
SHOW VARIABLES LIKE 'character_set%';修改 DB 編碼
ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;查看 TABLES 編碼
use dbname;
SELECT @@character_set_database, @@collation_database;
OR.
SHOW FULL COLUMNS FROM tablename;
OR.
SHOW FULL FIELDS FROM tablename;修改表的編碼為 UTF8
ALTER TABLE web CONVERT TO CHARACTER SET utf8;查看 DB 內所有表的狀態
SHOW TABLE STATUS FROM tablename \G;通過 SHOW CREATE TABLE 確認
SHOW CREATE TABLE web;
