Default MySQL character set and collation
February 10, 2011 Leave a Comment
All versions of MySQL on (mt) Media Temple server are installed with the default character set ‘latin1′. The default collation for latin1 is ‘latin1_swedish_ci’ which in most cases does not cause any problems.
You can also change the character set and collation of a database by using the following MySQL command:
ALTER DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;
You can also change the character set and collation of each table by using the following MySQL command:
ALTER TABLE TableName CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
Advertisement
