How to convert mysql database to utf8 ?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to convert mysql database to utf8 ?

Postby gabier » 08. November 2015 08:10

I want my local mysql database to be the same than the database on my distant site. At the moment the distant site is in utf 8 and the local site is the standard installation of XAMPP 1.8.3, which comes in latin1.
I have tried to modify the my.ini file which is in the XAMPP/Mysql/bin folder and uncomment the lines "UTF8 settings". But that resulted in phpmyadmin refusing to read the data base because of errors.
What is the correct way to convert an XAMPP 1.8.3 installation to utf8 ?

:) gabier
Posts: 10
Joined: 29. March 2013 18:22
Operating System: Windows 7

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests