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
Written by Russell England
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#