Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save carlaizumibamford/89d275097e9a8c620428 to your computer and use it in GitHub Desktop.
Save carlaizumibamford/89d275097e9a8c620428 to your computer and use it in GitHub Desktop.
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