MYSQL 查詢數據庫,表及字段的字符集
問題背景
字符集設置問題導致無法存儲表情等特殊的符號,需要將utf8改為utf8mb4
-- 檢查數據庫字符集
SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'your_database_name';
-- 檢查表字符集
SELECT TABLE_NAME, TABLE_COLLATION
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your_database_name';
-- 檢查列字符集
SELECT COLUMN_NAME, CHARACTER_SET_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_database_name'
AND TABLE_NAME = 'your_table_name';
修改語句
修改數據庫字符集:
ALTER DATABASE your_database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
修改表字符集:
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
修改列字符集:
ALTER TABLE your_table_name MODIFY logisticsTrack VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
惜秦皇漢武,略輸文采;唐宗宋祖,稍遜風騷。
一代天驕,成吉思汗,只識彎弓射大雕。
俱往矣,數風流人物,還看今朝

浙公網安備 33010602011771號