Skip to content

Instantly share code, notes, and snippets.

@raven-rock

raven-rock/mysql_change_character_set_collation.sql

Created July 5, 2019 17:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save raven-rock/a7ea59ea40a5b8189811d5cc20b3a9f8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save raven-rock/a7ea59ea40a5b8189811d5cc20b3a9f8 to your computer and use it in GitHub Desktop.
Download ZIP
Change MySQL character set and collation of existing table
Raw
mysql_change_character_set_collation.sql
-- UTF8mb4, case insensitive
ALTER TABLE my_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- Latin1, Swedish case insensitive
ALTER TABLE my_table CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment