14,953
edits
排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
→錯誤 1690 - BIGINT UNSIGNED 值超出範圍
| Line 313: | Line 313: | ||
SET sql_mode = 'NO_UNSIGNED_SUBTRACTION'; | SET sql_mode = 'NO_UNSIGNED_SUBTRACTION'; | ||
</pre> | </pre> | ||
=== 錯誤 1366: 字串值不正確 === | |||
訊息：SQLSTATE[HY000]: 一般錯誤：1366 字串值 '\xF0\x9F\x87\xAF\xF0\x9F...' 對於欄位 'XXX' 不正確 | |||
解決方案： | |||
* 檢查 PHP PDO 的字元集。並執行 {{kbd | key=set names utf8mb4}}<ref>[https://stackoverflow.com/questions/54947392/incorrect-string-value-when-trying-to-pass-emoji-to-the-db-encoded-with-utf8mb4 php - 嘗試將使用 utf8mb4 編碼的表情符號傳遞給資料庫時字串值不正確 - Stack Overflow]</ref> | |||
* 檢查表的配置 | |||
** 字元集 (字元集、字元集): {{kbd | key=utf8mb4}} | |||
** 排序規則 (定序、字元序): {{kbd | key=utf8mb4_unicode_ci}} | |||
== 資源和環境錯誤 == | == 資源和環境錯誤 == | ||