Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
My Code:
C#
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.
Posted

1 solution

take datatype nVarchar in place of Varchar or ntext and
write parametrized query to insert values
C#
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 );
 
Share this answer
 
Comments
UL UL ALBAB 24-Jul-14 8:06am    
There is no any nVarchar datatype in Mysql Database. In Collation field I have set utf8_general_ci. And manually Bangla is inserting. But, by C# it's not working.
Manoj Kumar Choubey 24-Jul-14 23:13pm    
yes nvarchar is for sql server not for mysql you can use varchar

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900