Skip to content

Instantly share code, notes, and snippets.

@tafid

tafid/How to convert an entire MySQL database characterset and collation to UTF-8?

Created November 28, 2016 13:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tafid/bb7d01ba2a57ae81678d5e17ebccacae to your computer and use it in GitHub Desktop.
Save tafid/bb7d01ba2a57ae81678d5e17ebccacae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
How to convert an entire MySQL database characterset and collation to UTF-8?
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment