Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→ERROR 1366: Incorrect string value
(+ 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 COLLATE of table e.g. utf8mb4_unicode_ci | |||
== Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied == | == Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied == | ||