Skip to content

Instantly share code, notes, and snippets.

@pandauxstudio

pandauxstudio/gist:9379460

Last active August 29, 2015 13:57
Show Gist options
  • Save pandauxstudio/9379460 to your computer and use it in GitHub Desktop.
Save pandauxstudio/9379460 to your computer and use it in GitHub Desktop.
Download ZIP
Change database and table character set, this is useful for supporting Arabic language
Raw
gistfile1.sql
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment