How to Store Regional Language in Database
Today we’ll see How to Store Regional Language in Database. In this tutorial you’ll see that how to store Indian Languages like Hindi, Marathi, Assamese, Bengali and etc into the database. Follow the steps –
1. While creating tables in Database, set the attribute property to UTF-8 i.e. Charset – utf8 and Collation – utf8_unicode_ci.
2. With the help of this you can easily store the regional language data.
3. Now in the connection coding you have to add one thing which is character set. It help to store the data in the database.
Public Sub Connection ()
con = New MySqlConnection
con.ConnectionString = “Server=localhost; Userid=root; Password=; Database=db_tutorial; Port=3306;
cmd.Connection = con
4. Character set helps you to store the data in the database.