wzg2gq
Last Updated: February 25, 2016
·
126
· buithehoa
Avatar fb

MySQL: Change Character Set and Collation of Table and Columns

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

2 Responses
Add your response

17783
D42a7264714dee5006b9c99d2567a320

So will that override the default collations on individual columns?

over 1 year ago ·
17784
Avatar fb

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

over 1 year ago ·