問題背景

字符集設置問題導致無法存儲表情等特殊的符號，需要將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;