While I was working with Nepali Unicode in PHP and MySql, I found difficulty in inserting Nepali into database. I made some explorations and found a way to deal with this.
There are some basic things you need to be careful when working with Unicode, especially with database.
The database itself should be encoded in UTF-8 format and whatever is the method to access that particular database, The programming language should be aware that the database is UTF-8 enocded.
The field to store Unicode text should also be changed to<Strong>utf8_general_ci</strong> under collations.
1. How to create database UTF-8 encoded.
a. Start Phpmyadmin, Then enter the database name
Under MySql Connection Collation select utf8_general_ci then hit create.
See the figure below