This shows you the differences between the selected revision and the current version of the page.
| vanilla:administrators:encodings 2009/03/28 14:19 | vanilla:administrators:encodings 2009/11/26 19:50 current | ||
| Line 1: | Line 1: | ||
| ====== Characters encodings, the UTF-8 conundrum ====== | ====== Characters encodings, the UTF-8 conundrum ====== | ||
| + | |||
| There has been a lot of discussion on the community forum regarding character encoding in Vanilla and MySQL. This page is intended to help resolve issues related to this subject. | There has been a lot of discussion on the community forum regarding character encoding in Vanilla and MySQL. This page is intended to help resolve issues related to this subject. | ||
| Line 18: | Line 19: | ||
| ==== Why UTF-8 ==== | ==== Why UTF-8 ==== | ||
| + | |||
| * ASCII is (was) the main widespread charset, but it is limited to the english language. | * ASCII is (was) the main widespread charset, but it is limited to the english language. | ||
| * Latin1 (ISO-8859-1) allows for some accented characters and is limited to some western languages. French can be written with it, but not Romanian or Czech. It is compatible with ASCII codes under 128(dec). | * Latin1 (ISO-8859-1) allows for some accented characters and is limited to some western languages. French can be written with it, but not Romanian or Czech. It is compatible with ASCII codes under 128(dec). | ||
| Line 33: | Line 35: | ||
| ==== What is my situation ? ==== | ==== What is my situation ? ==== | ||
| + | |||
| ^ case # ^ Vanilla charset ^ connection charset ^ database charset ^ database state ^ comment ^ | ^ case # ^ Vanilla charset ^ connection charset ^ database charset ^ database state ^ comment ^ | ||
| | 1 | utf8 | utf8 | utf8 | OK | Vanilla correctly setup for any character entry | | | 1 | utf8 | utf8 | utf8 | OK | Vanilla correctly setup for any character entry | | ||
| Line 53: | Line 56: | ||
| === Why should I fix ? === | === Why should I fix ? === | ||
| + | |||
| If you read the preceding chapter you should be convinced already. | If you read the preceding chapter you should be convinced already. | ||
| + | |||
| ==== Cleaning ==== | ==== Cleaning ==== | ||
| Line 96: | Line 101: | ||
| ==== Character Sets and Collations ==== | ==== Character Sets and Collations ==== | ||
| + | |||
| These are the character sets available in phpmyadmin, when you first setup your database. Use utf8_general_ci or utf8_unicode_ci for universal, multilingual support. | These are the character sets available in phpmyadmin, when you first setup your database. Use utf8_general_ci or utf8_unicode_ci for universal, multilingual support. | ||