![]() The default collation for the utf8 character set, is utf8_general_ci. As you may start to imagine, latin1_swedish_ci (the "ci" suffix means "case insensitive") is the default collation for the latin1 character set, and that is why you have: The table charset and collation are used as default values for column definitions when the column charset and collation are not specified in individual column definitions.Īs you can see, your server and database character sets are defined as latin1:Īs a character set can have more than one collations, a default one is always defined for each character set. The database charset and collation are used as default values for table definitions when the table charset and collation are not specified in CREATE TABLE statements. The server charset and collation are used as default values when the database charset and collation are not specified in CREATE DATABASE statements. The MySQL database server has default settings for character sets (charset) and collations at four levels: With this you'll be able to create the database dump.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |