Last Updated: February 25, 2016
·
281
· buithehoa

MySQL: Change Character Set and Collation of Table and Columns

ALTER TABLE <table_name> CONVERT TO CHARACTER SET <character_set> COLLATE <collation>;

2 Responses
Add your response

So will that override the default collations on individual columns?

over 1 year ago ·

@dpashkevich Yes. After executing the above, if you create a new column, the new collation will be applied.

over 1 year ago ·