Mysql server does not support 4-byte encoded utf8 characters

by

If you need MySQL to support 4-byte UTF-8 characters (which is normally considered part of UTF-8), you need to use the character set utf8mb4, not utf8. utf8mb4 was first supported in MySQL 5.5.3.

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. Trouble with UTF-8 characters; what I see is not what I stored
  6. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  7. How to make MySQL handle UTF-8 properly
  8. How to conduct an Accent Sensitive search in MySql
  9. How to display UTF-8 characters in phpMyAdmin?
  10. UTF-8: General? Bin? Unicode?
  11. How to remove accents in MySQL?
  12. MySQL utf8mb4, Errors when saving Emojis
  13. Differences between utf8 and latin1
  14. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  15. MySQL VARCHAR Lengths and UTF-8
  16. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  17. Fetching UTF-8 text from MySQL in R returns “????”
  18. How to fix double-encoded UTF8 characters (in an utf-8 table)
  19. What characters have to be escaped to prevent (My)SQL injections?
  20. Loading utf-8 encoded text into MySQL table
  21. MySQL command line formatting with UTF8
  22. Detecting utf8 broken characters in MySQL
  23. The ultimate emoji encoding scheme
  24. UTF8 problem with MySQL 5
  25. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  26. How do I escape reserved words used as column names? MySQL/Create Table
  27. What is the opposite of GROUP_CONCAT in MySQL?
  28. How to Perform an UPSERT so that I can use both new and old values in update part
  29. MySQL multiple columns in IN clause
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment