New answers tagged character-set
Run in PhpMyAdmin: ALTER DATABASE yourdatabasename CHARACTER SET utf8 COLLATE utf8_unicode_ci
You can't install UTF-8 as a character set because it's not a character set, it is an encoding. If you want to store Unicode text you use the nvarchar data type. If you want to store text encoded using UTF-8, you store it as binary data (varbinary).
Straight from the Manual: The easiest approach to migrating convertible data dictionary data is to create a new database in the target character set and then re-create all of the data dictionary and schema definitions by exporting and importing. However, this method means creating a new database. Based on what I'm reading in this manual, that's ...
Top 50 recent answers are included