RSS

Monthly Archives: February 2013

urdu save in Mysql & Retrieve in application


if you want to save urdu language in MySql databse the you need to be keep datatype is

BLOB

mysql urdu

Is your BLOB stored as utf8 byte values? or other character set?
CAST(a.ar_options AS CHAR(10000) CHARACTER SET utf8)

below conversation use for string to byte[]  Error for:

System.Text.Encoding.UTF8.GetBytes(” “)

emp.Name =System.Text.Encoding.UTF8.GetBytes(txtFullName.Text);
emp.FatherName = System.Text.Encoding.UTF8.GetBytes(txtfathername.Text);
emp.MotherName =System.Text.Encoding.UTF8.GetBytes( txtMotherName.Text);
emp.Adob = Convert.ToDateTime(txtdobactual.Text);
emp.NAdob = Convert.ToDateTime(txtdobtemprary.Text);

 
Leave a comment

Posted by on February 22, 2013 in SQL Query, WinForm

 

Tags: , ,