New SQL doesn't support UTF-8

Bentok

Member
Jan 14, 2015
6
0
1
cPanel Access Level
Website Owner
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?
 

Bentok

Member
Jan 14, 2015
6
0
1
cPanel Access Level
Website Owner
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

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
I am happy to see the issue was addressed. Thank you for updating us with the outcome.