How to insert unicode string into sql server using c#

Question

Hi have a sql string where want insert data to sql server , how to use N when i add values like @value

SqlCommand cmd = new SqlCommand("Insert into News (News,title) values (@news,@title)", conn);
string news = TextBox1.Text;
string title = TextBox2.Text;

cmd.Parameters.AddWithValue(@"news", news);
cmd.Parameters.AddWithValue(@"title", title);

You don't need to use `N`. – Hamlet Hakobyan Sep 21 '13 at 11:34 — Hamlet Hakobyan, Sep 21 '13 at 11:34
Hpw do it ? i add non english string – R01 Sep 21 '13 at 11:37 — R01, Sep 21 '13 at 11:37
Do you have tried without `N`? – Hamlet Hakobyan Sep 21 '13 at 11:39 — Hamlet Hakobyan, Sep 21 '13 at 11:39
What datatype are your columns in the `News` table? – marc_s Sep 21 '13 at 13:47 — marc_s, Sep 21 '13 at 13:47

score 3 · Answer 1 · answered Sep 21 '13 at 13:49

Code seems fine - and no, you don't need to use the N prefix anywhere in such a scenario (only when you're writing a string literal in e.g. Management Studio).

The only thing that might be something to look into is explicitly specifying the parameter types:

cmd.Parameters.Add("@news", SqlDbType.NVarChar, 100).Value = news;
cmd.Parameters.Add("@title", SqlDbType.NVarChar, 100).Value = title;

but usually, ADO.NET is pretty good at guessing the right datatype, especially since .NET strings are in fact Unicode already.

How to insert unicode string into sql server using c#

1 Answers1