Skip to main content
Database Administrators

Return to Answer

replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link
Community Bot
Community Bot
  • 1

You had latin1 somewhere. See http://stackoverflow.com/a/38363567/1766831https://stackoverflow.com/a/38363567/1766831 . Do...

  • the SELECT HEX ... to see whether you have the correct utf8 encoding: E28099.
  • SHOW CREATE TABLE to see what CHARACTER SET that column has.
  • SHOW VARIABLES LIKE 'char%'; to see what the connection is like.

Read about Mojibake.

You had latin1 somewhere. See http://stackoverflow.com/a/38363567/1766831 . Do...

  • the SELECT HEX ... to see whether you have the correct utf8 encoding: E28099.
  • SHOW CREATE TABLE to see what CHARACTER SET that column has.
  • SHOW VARIABLES LIKE 'char%'; to see what the connection is like.

Read about Mojibake.

You had latin1 somewhere. See https://stackoverflow.com/a/38363567/1766831 . Do...

  • the SELECT HEX ... to see whether you have the correct utf8 encoding: E28099.
  • SHOW CREATE TABLE to see what CHARACTER SET that column has.
  • SHOW VARIABLES LIKE 'char%'; to see what the connection is like.

Read about Mojibake.

Source Link
Rick James
Rick James
  • 79.4k
  • 5
  • 51
  • 117

You had latin1 somewhere. See http://stackoverflow.com/a/38363567/1766831 . Do...

  • the SELECT HEX ... to see whether you have the correct utf8 encoding: E28099.
  • SHOW CREATE TABLE to see what CHARACTER SET that column has.
  • SHOW VARIABLES LIKE 'char%'; to see what the connection is like.

Read about Mojibake.