How to insert a unicode character in SQL Server using Inline Query

Question

I am using inline query in asp.net but problem is i dont now how to use N suffix properly pls guide....

  cn.Open();
    SqlCommand cmd = new SqlCommand("insert into newsactivity VALUES(@newstitle, @newsdetails ,@dated,@type)",cn);
    cmd.Parameters.AddWithValue("@newstitle",txtnewstitle.Text);
    cmd.Parameters.AddWithValue("@newsdetails",N'txtnewsdetails.Text');

When you are using parameters then setting SqlDbType to NVarChar should be good enough — V4Vendetta
– V4Vendetta, Commented Jun 18, 2012 at 5:55

John Gathogo · Accepted Answer · 2012-06-18 06:05:18Z

5

It should be enough to say

cmd.Parameters.AddWithValue("@newsdetails", txtnewsdetails.Text);

EDIT: Should that fail, then this should work:

cmd.Parameters.Add("@newsdetails", SqlDbType.NVarChar, 1024).Value = txtnewsdetails.Text;

edited Jun 18, 2012 at 6:05

answered Jun 18, 2012 at 5:59

John Gathogo

4,6753 gold badges36 silver badges50 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:55:47Z

4

You don't need to. .NET strings are already unicode. N is just tells Query Analyzer that the string literal after the N is Unicode.

e.g.

cmd.Parameters.AddWithValue("@newsdetails","मैं stackoverflow प्यार है");

Just make sure that the field newsdetails in your newsactivity table is NVARCHAR(..)

Edit That's strange. Possibly AddWithValue hasn't inferred the type of the parameter correctly. You can specify it explicitly:

SqlParameter param = cmd.Parameters.AddWithValue("@newsdetails",txtnewsdetails.Text);
param.SqlDbType = SqlDbType.NVarChar;

Another good reason to specify the type and length explicitly is if you are using the parameter in a WHERE clause filter. See AddWithValue without DBType causing queries to run slowly

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Jun 18, 2012 at 5:57

StuartLC

108k18 gold badges225 silver badges294 bronze badges

1 Comment

Shivesh Narang Over a year ago

its nvarchar already ... and its a freetextbox but after saving it displays ????? chars....how ever sql server accepts unicode when i insert it directly in sql server

Kishore Kumar · Accepted Answer · 2012-06-18 06:30:08Z

0

use SqlDbType.NVarChar in your parameter.

answered Jun 18, 2012 at 6:30

Kishore Kumar

12.9k27 gold badges99 silver badges158 bronze badges

Collectives™ on Stack Overflow

How to insert a unicode character in SQL Server using Inline Query

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related