MySQL: Change Character Set and Collation of Table and Columns
ALTER TABLE <table_name> CONVERT TO CHARACTER SET <character_set> COLLATE <collation>;
Written by Bui The Hoa
Related protips
2 Responses
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
·
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#