ASP.NET , Mysql and Unicode for Hindi

ASP.NET , Mysql and Unicode for Hindi

Step 1. In mysql table structure change latin1_swedish_ci  to utf8_unicode_ci  


subject text utf8_unicode_ci
sender text latin1_swedish_ci

Step2: Add Character Set=utf8; in your connection string

add name="vinConn" connectionString="server=191.254.1.42;User Id=admin;password=**;database=entertrack;Persist Security Info=True;Character Set=utf8; " providerName="MySql.Data.MySqlClient"/>
Step3: Use N in insert statement
like insert into tesr (subject) values (N'महानदी ')

Comments

Most Viewed Post

solution for facebook static.ak.fbcdn.net waiting

Connect Sony XPLOD MEX-BT2500 Bluetooth CD Receiver with ur mobile

Crystal Report : Show data horizontally (Left to right) i.e. columns as rows

Google+ Followers