通过C#Windows应用程序将Bangla插入MySQL数据库
问题描述:
我的代码:
My Code:
try
{
if (Lang.Culture.EnglishName == "Bengali(Bangladesh)")
InputLanguage.CurrentInputLanguage = Lang;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
try
{
//db_mysql.OpenConnection();
db_mysql.Adapter("SET CHARACTER SET utf8");
db_mysql.Adapter("SET SESSION collation_connection ='utf8_general_ci'");
db_mysql.Adapter("INSERT INTO tbl_b (keyword, message, date) VALUES ('" + keyword + "', '" + message + "', '" + date + "')");
//MessageBox.Show(message);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
在我的数据库中插入后显示?????? ??登录数据库。
After Insert in my database showing "?????? ??" sign in database.
答
取数据类型nVarchar代替Varchar或ntext和
写入参数化查询以插入值
take datatype nVarchar in place of Varchar or ntext and
write parametrized query to insert values
INSERT INTO tbl_b (keyword, message, date) VALUES (@fname,@lname,@age)"
mySqlCommand.Parameters.Add("@fname", keyword);
mySqlCommand.Parameters.Add("@lname", message);
mySqlCommand.Parameters.Add("@age" , date );