Hello friends,
I am fetching mail using Gmail and its working well if Mail content is in English. But My requirement is if mail is in Hindi(Indian Language) or there is some attachment how to save them in Datbase(MY-SQL). Hindi fonts are showing as a "?????????" in the database.
public void InsertMail(string uid, string from, string to, string subject, DateTime datetime, string message)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.Parameters.AddWithValue("@unique_id", uid);
cmd.Parameters.AddWithValue("@sender", from);
cmd.Parameters.AddWithValue("@reciever", to);
cmd.Parameters.AddWithValue("@subject", subject);
cmd.Parameters.AddWithValue("@date", datetime);
cmd.Parameters.AddWithValue("@message", message);
cmd.Parameters.AddWithValue("@mail_status", "unread");
cmd.Connection = con;
string query = "Insert Ignore into gmail_inbox1(unique_id,sender,reciever,subject,date,message,mail_status) values (@unique_id,@sender,@reciever,@subject,@date,@message,@mail_status) ";
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}
Thanks & Regards
Neetesh