New SQL doesn't support UTF-8

Bentok

• January 14, 2015 11:14

Hello, I was using SQL 5.0, in the sql it looks like this: """ But in the site it's showing fine. (all table has same value in old and new version to UTF-8 General, I tried other value also). But when I upgraded SQL to newest version: 5.6, have issue, the char is like this in the sql and site: """ When opening the site it's the same like this and I tried to to everything but it's like this again: """ Any one has any idea how to fix this with new version of SQL?

• 

  cPanelMichael

  • January 14, 2015 18:56

  Hello :) Could you post the output of "show collation;" after typing "mysql" via the command line? Also, please note the following MySQL documents: [url=http://dev.mysql.com/doc/refman/5.6/en/charset-configuration.html]MySQL :: MySQL 5.6 Reference Manual :: 10.5 Character Set Configuration [url=http://dev.mysql.com/doc/refman/5.6/en/charset.html]MySQL :: MySQL 5.6 Reference Manual :: 10.1 Character Set Support Thank you.

  0
• 

  Bentok

  • January 14, 2015 20:33

  Hello, Thanks for informations, fixed the issue! Here is the solution: Easiest way to fix MySQL UTF8 to Latin1 character set encoding issues. Site: /http://www.garethsprice.com/blog/2011/fix-mysql-latin1-utf-character-encoding/ Thanks!

  0
• 

  cPanelMichael

  • January 15, 2015 00:54

  I am happy to see the issue was addressed. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.