Skip to content

Instantly share code, notes, and snippets.

@mrsweaters

mrsweaters/gist:761e87a55bab02a6a5a0

Created June 13, 2014 21:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrsweaters/761e87a55bab02a6a5a0 to your computer and use it in GitHub Desktop.
Save mrsweaters/761e87a55bab02a6a5a0 to your computer and use it in GitHub Desktop.
Download ZIP
Update Collation in MySQL
Raw
gistfile1.txt
mysql> show table status;
```
+----------+--------+-------------------+ ..
| Name | Engine | Collation | ..
+----------+--------+-------------------+ ..
| my_table | InnoDB | latin1_swedish_ci | ..
```
Therefore I altered the character set of the table directly:
`ALTER TABLE my_table CONVERT TO CHARACTER SET utf8;`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment