Fetching UTF-8 text from MySQL in R returns “????”

by

Thanks to @chooban I found out the connection session was using latin1 instead of utf8. Here are two solutions I found:

  • For RMySQL, after connecting run the query SET NAMES utf8 to change the connection character set.
  • For RODBC, connect using CharSet=utf8 in the DSN string. I was not able to run SET NAMES via ODBC.

This question pointed me in the right direction.

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  3. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  4. How to fix double-encoded UTF8 characters (in an utf-8 table)
  5. How to convert an entire MySQL database characterset and collation to UTF-8?
  6. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  7. Change MySQL default character set to UTF-8 in my.cnf?
  8. How to make MySQL handle UTF-8 properly
  9. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  10. How to conduct an Accent Sensitive search in MySql
  11. How can I find non-ASCII characters in MySQL?
  12. UTF-8: General? Bin? Unicode?
  13. Save Data in Arabic in MySQL database
  14. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  15. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  16. Force character vector encoding from “unknown” to “UTF-8” in R
  17. Read a UTF-8 text file with BOM
  18. Loading utf-8 encoded text into MySQL table
  19. adding RMySQL package to R fails (on Windows)?
  20. How to change the default charset of a MySQL table?
  21. How to search for rows containing a substring?
  22. RMySQL dbWriteTable with field.types
  23. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  24. Detecting utf8 broken characters in MySQL
  25. MySQL throws Incorrect string value error
  26. Manipulating files with non-English names in R
  27. UTF-8 not working in HTML forms
  28. Mysql server does not support 4-byte encoded utf8 characters
  29. UTF8 problem with MySQL 5
  30. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’

Leave a Comment