When changing a character set and not specifying a collation, the default collation for the new character set is always used.Ĭharacter sets and collations always cascade down, so a column without a specified collation will look for the table default, the table for the database, and the database for the server. Both character sets and collations can be specified from the server right down to the column level, as well as for client-server connections. In MariaDB, the default character set is latin1, and the default collation is latin1_swedish_ci (however this may differ in some distros, see for example Differences in MariaDB in Debian). Example: Changing the Default Character Set To UTF-8.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |