Skip to content

Instantly share code, notes, and snippets.

@carlaizumibamford

carlaizumibamford/How to change the default charset to UTF-8 on XAMMP (MySQL)

Created November 10, 2014 21:06
Show Gist options
  • Star 6 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save carlaizumibamford/89d275097e9a8c620428 to your computer and use it in GitHub Desktop.
Save carlaizumibamford/89d275097e9a8c620428 to your computer and use it in GitHub Desktop.
Download ZIP
How to change the default charset to UTF-8 on XAMMP (MySQL)
Raw
How to change the default charset to UTF-8 on XAMMP (MySQL)
1. Open "my.ini" in "C:\xampp\mysql\bin\" directory.
2. Edit the following lines.
# Add the following code before [client].
default-character-set=utf8
# Add the following code before [mysqld].
character-set-server=utf8
skip-character-set-client-handshake
# Add the following code before [mysqldump].
default-character-set=utf8
# Add the following code before [mysql].
default-character-set=utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment