Skip to content

Instantly share code, notes, and snippets.

@peschmae

peschmae/right way

Created August 8, 2014 17:33
Show Gist options
  • Save peschmae/d09935611a960ab13a7c to your computer and use it in GitHub Desktop.
Save peschmae/d09935611a960ab13a7c to your computer and use it in GitHub Desktop.
Download ZIP
Charset Conversion
Raw
right way
ALTER TABLE <TABLENAME> CHANGE <COLUMNNAME> <COLUMNNAME> VARCHAR(255) CHARACTER SET latin1;
ALTER TABLE <TABLENAME> CHANGE <COLUMNNAME> <COLUMNNAME> VARBINARY(255);
ALTER TABLE <TABLENAME> CHANGE <COLUMNNAME> <COLUMNNAME> VARCHAR(255) CHARACTER SET utf8;
Raw
wrong.....
ALTER DATABASE <DATABASE> 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