Database convert character_set_server latin1 to utf8
0
votes
1
answer
1707
views
I am writing about a problem on the character encoding that i have on my site with Magento. In practice, the special characters do not take utf8 and gives me the classic non-coded characters: Ã.
These are the codes in my database:
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
My question is ... the problem of encoding is caused by character_set_server latin1 string? How do I convert my database character_set_server latin1 to utf8? It can be a very simple Query?
Thanks so much
Asked by Gabriel91
(101 rep)
May 9, 2016, 10:06 AM
Last activity: Jul 8, 2017, 12:23 PM
Last activity: Jul 8, 2017, 12:23 PM