Skip to content

Instantly share code, notes, and snippets.

@grzegorzblaszczyk

grzegorzblaszczyk/mysql_convert_to_utf_8.sql

Created October 8, 2014 08:41
Show Gist options
  • Save grzegorzblaszczyk/62e5f77eda9ee02dc4d4 to your computer and use it in GitHub Desktop.
Save grzegorzblaszczyk/62e5f77eda9ee02dc4d4 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql convert to UTF-8
Raw
mysql_convert_to_utf_8.sql
ALTER DATABASE [database_name] CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE [table_name] 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