Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL

by

I was finally able to figure out the issue.
I had to change some settings in mysql configuration my.ini
This article helped a lot
http://mathiasbynens.be/notes/mysql-utf8mb4#character-sets

First i changed the character set in my.ini to utf8mb4
Next i ran the following commands in mysql client

SET NAMES utf8mb4; 
ALTER DATABASE dreams_twitter CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;

Use the following command to check that the changes are made

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  3. How to make MySQL handle UTF-8 properly
  4. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  5. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  6. How to conduct an Accent Sensitive search in MySql
  7. How to display UTF-8 characters in phpMyAdmin?
  8. UTF-8: General? Bin? Unicode?
  9. How to remove accents in MySQL?
  10. Differences between utf8 and latin1
  11. MySQL VARCHAR Lengths and UTF-8
  12. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  13. Fetching UTF-8 text from MySQL in R returns “????”
  14. How to fix double-encoded UTF8 characters (in an utf-8 table)
  15. Loading utf-8 encoded text into MySQL table
  16. MySQL command line formatting with UTF8
  17. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  18. Detecting utf8 broken characters in MySQL
  19. MySQL throws Incorrect string value error
  20. Mysql server does not support 4-byte encoded utf8 characters
  21. UTF8 problem with MySQL 5
  22. How to properly create composite primary keys – MYSQL
  23. How can I Insert many rows into a MySQL table and return the new IDs?
  24. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  25. Using ORDER BY and GROUP BY together
  26. MySQL Pivot Table Column Data as Rows
  27. updating columns with a sequence number mysql
  28. Select all months within given date span, including the ones with 0 values
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. WHERE datetime older than some time (eg. 15 minutes)

Leave a Comment