Save Sinhala Unicode Characters in MySQL

Here I am going to explain how to save Sinhala Unicode Characters in a MySQL table. It is not a very hard thing to do. Only thing that need to do is, set “COLLATE” type as “utf8_unicode_ci”. Below I have explained step by step, how to do that using phpmyadmin in WAMP Server.

Step 1 : Start WAMP and then open phpmyadmin.

Step 2 : Create a new database as below. Set the database name and Collate type as                                           “utf8_unicode_ci”.

Step 3: Now create a table describes as below. Set “Collation” to “utf8_unicode_ci” in every table column.

After successfully creating the table, you can insert Sinhala Unicode characters to the table.