help me inserting in database the arabic characters

[Mogaambo]

// Tell me how where i am going wrong public int InsertMake(Create_make_bean makedetails) { String connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(connectionstring)) { String strquery; strquery = "insert into year_tb ("; strquery += "year,make,model"; strquery += ") "; strquery += "values(@year, @make, @model)"; SqlCommand cmd = new SqlCommand(strquery, con); cmd.Parameters.AddWithValue("@year", 'N'+makedetails.year); cmd.Parameters.AddWithValue("@make", 'N'+makedetails.make); cmd.Parameters.AddWithValue("@model",'N'+makedetails.model); try { con.Open(); int inserted = cmd.ExecuteNonQuery(); return inserted; } catch(Exception ex) { return 0; } finally { con.Close(); } } }

[Kannan Coder]

use nvarchar data type to store unicode characters. By the way is this code makes any errors?

[Mogaambo]

sorted out, i am using year as column name and year in mssqlserver is reserved