Last Updated: February 25, 2016
·
1.5K
· russellengland

Change the collation for all columns

Changing the collation for a table will only set the collation for the next column that is added.

To change all of the existing columns to the new collation :

ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci