New SQL doesn't support UTF-8

[Bentok]

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]

Hello

Could you post the output of "show collation;" after typing "mysql" via the command line?

Also, please note the following MySQL documents:

MySQL :: MySQL 5.6 Reference Manual :: 10.5 Character Set Configuration
MySQL :: MySQL 5.6 Reference Manual :: 10.1 Character Set Support

Thank you.

 

[Bentok]

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!

 

[cPanelMichael]

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