MySQL utf8mb4, Errors when saving Emojis

by

character_set_client, _connection, and _results must all be utf8mb4 for that shortcake to be eatable.

Something, somewhere, is setting a subset of those individually. Rummage through my.cnf and phpmyadmin’s settings — something is not setting all three.

If SET NAMES utf8mb4 is executed, all three set correctly.

The sun shone because it is only 3-bytes – E2 98 80; utf8 is sufficient for 3-byte utf8 encodings of Unicode characters.

More Related Contents:

  1. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  2. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  3. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  4. MySQL throws Incorrect string value error
  5. Mysql server does not support 4-byte encoded utf8 characters
  6. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  7. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  8. MySQL string replace
  9. How do I find the MySQL my.cnf location
  10. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  11. MySQL select one column DISTINCT, with corresponding other columns
  12. How to use mysql JOIN without ON condition?
  13. Why is MySQL InnoDB insert so slow?
  14. How to create linked server MySQL
  15. Group mysql query by 15 min intervals
  16. MySQL FULL JOIN?
  17. How to fill in the “holes” in auto-increment fields?
  18. Using Count to find the number of occurrences
  19. Is there any reason to worry about the column order in a table?
  20. How to change MySQL table names in Linux server to be case insensitive?
  21. MySQL command line formatting with UTF8
  22. MYSQL select DISTINCT values in two columns
  23. Use promise to process MySQL return value in node.js
  24. How can I achieve initcap functionality in MySQL?
  25. MySQL vs. JSON – Why? [closed]
  26. Find method to store an IP in MySQL for better performance
  27. MySQL add 12 hours to a time field
  28. OSX ld: library not found for -lssl
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment