“Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?

by

MySQL’s utf8 permits only the Unicode characters that can be represented with 3 bytes in UTF-8. Here you have a character that needs 4 bytes: \xF0\x90\x8D\x83 (U+10343 GOTHIC LETTER SAUIL).

If you have MySQL 5.5 or later you can change the column encoding from utf8 to utf8mb4. This encoding allows storage of characters that occupy 4 bytes in UTF-8.

You may also have to set the server property character_set_server to utf8mb4 in the MySQL configuration file. It seems that Connector/J defaults to 3-byte Unicode otherwise:

For example, to use 4-byte UTF-8 character sets with Connector/J, configure the MySQL server with character_set_server=utf8mb4, and leave characterEncoding out of the Connector/J connection string. Connector/J will then autodetect the UTF-8 setting.

More Related Contents:

  1. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  2. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  3. MySQL throws Incorrect string value error
  4. Mysql server does not support 4-byte encoded utf8 characters
  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 fix: “No suitable driver found for jdbc:mysql://localhost/dbname” error when using pools? [duplicate]
  9. How to conduct an Accent Sensitive search in MySql
  10. JDBC batch insert performance
  11. How to display UTF-8 characters in phpMyAdmin?
  12. UTF-8: General? Bin? Unicode?
  13. What is the MySQL JDBC driver connection string?
  14. In Apache Spark 2.0.0, is it possible to fetch a query from an external database (rather than grab the whole table)?
  15. How to remove accents in MySQL?
  16. MySQL utf8mb4, Errors when saving Emojis
  17. Differences between utf8 and latin1
  18. Am I Using JDBC Connection Pooling?
  19. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  20. MySQL VARCHAR Lengths and UTF-8
  21. SQLException: No suitable driver found [duplicate]
  22. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  23. Fetching UTF-8 text from MySQL in R returns “????”
  24. How to fix double-encoded UTF8 characters (in an utf-8 table)
  25. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  26. MySQL command line formatting with UTF8
  27. Where can I download mysql jdbc jar from? [closed]
  28. Detecting utf8 broken characters in MySQL
  29. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  30. What is the jdbc driver “org.gjt.mm.mysql.Driver” for?

Leave a Comment