Skip to content

Instantly share code, notes, and snippets.

@marcuswestin

marcuswestin/mysql-emoji-charset.sql

Created February 28, 2014 13:01
Show Gist options
  • Save marcuswestin/9270645 to your computer and use it in GitHub Desktop.
Save marcuswestin/9270645 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql charset fix for emojis in text columns.
Raw
mysql-emoji-charset.sql
CREATE TABLE message (
body TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
);
-- Then add to conf: `character-set-server = utf8mb4`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment