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
– Hamlet Hakobyan

2013-09-21 11:34:50 +00:00
Commented Sep 21, 2013 at 11:34 — Hamlet Hakobyan
– Hamlet Hakobyan, Commented Sep 21, 2013 at 11:34
Hpw do it ? i add non english string

R01
– R01

2013-09-21 11:37:42 +00:00
Commented Sep 21, 2013 at 11:37 — R01
– R01, Commented Sep 21, 2013 at 11:37
Do you have tried without N?

Hamlet Hakobyan
– Hamlet Hakobyan

2013-09-21 11:39:23 +00:00
Commented Sep 21, 2013 at 11:39 — Hamlet Hakobyan
– Hamlet Hakobyan, Commented Sep 21, 2013 at 11:39
What datatype are your columns in the News table?

marc_s
– marc_s

2013-09-21 13:47:15 +00:00
Commented Sep 21, 2013 at 13:47 — marc_s
– marc_s, Commented Sep 21, 2013 at 13:47

marc_s · Accepted Answer · 2013-09-21 13:49:44Z

3

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.

answered Sep 21, 2013 at 13:49

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert unicode string into sql server using c#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related