After upgrading to PhpMyAdmin version: 3.4.5 (which comes in XAMPP 1.7.7-VC9), I noticed that the default collation of MySql is set to “latin1_swedish_ci”.Due to this, whenever a new database is created using phpMyAdmin, it sets the collation as latin1_swedish_ci by default(there will be no problem due this though). We can change this to “utf8_general_ci” / “utf8_unicode_ci” by selecting the needed one before creating the database. If we forgot to select the right one, then it will make the collation as “latin1_swedish_ci”. 🙁
Change the default collation to utf8_general_ci in MySql:
- Open the my.ini file. (C:xamppmysqlbinmy.ini)
- Find the text [mysqld] and add the below lines.
12345<strong>[mysqld]character–set–server = utf8collation–server = utf8_general_ci</strong>
The above two lines will select a character set and collation at server startup. These settings apply server-wide and apply as the defaults for databases created by any application, and for tables created in those databases.
- Save the file and restart the mysql server.(XAMPP Control Panel -> Stop -> Start)
For more info read: Configuring the Character Set and Collation for Applications