wzg2gq
Last Updated: February 25, 2016
·
144
· 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

17783

So will that override the default collations on individual columns?

over 1 year ago ·
17784

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

over 1 year ago ·