Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1366: Incorrect string value
| Line 215: | Line 215: | ||
Solution: | Solution: | ||
* Check the charset of PHP PDO. AND execute {{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 - Incorrect string value when trying to pass emoji to the db encoded with utf8mb4 - Stack Overflow]</ref> | * Check the charset of PHP PDO. AND execute {{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 - Incorrect string value when trying to pass emoji to the db encoded with utf8mb4 - Stack Overflow]</ref> | ||
* Check the | * Check the configuration of table | ||
** CHARACTER SETS (aka 字元集、字符集): {{kbd | key=utf8mb4}} | |||
** COLLATION (aka 定序、字元序): {{kbd | key=utf8mb4_unicode_ci}} | |||
== Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied == | == Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied == | ||