How to insert new line to nvarchar using c# code

Question

I have a table with a field ,description nvarchar(200).

I am inserting string with a lot of lines.

When I take quick watch over the string in visual studio, I can see the string splited over mutile lines as i expected.

line1
line2
line3

But when I insert to database using a stored procedure,all "\n\r" beomes just spaces. When I read from the databse there is no "\n\r"

what can i do?

Is the stored procedure removing char #10 #3 and replacing them with spaces. — rerun
– rerun, Commented Apr 11, 2011 at 17:08

Daniel A. White · Accepted Answer · 2011-04-11 17:08:26Z

14

It should be stored just fine. When you look through SSMS, it removes the newlines for readability in its grid.

answered Apr 11, 2011 at 17:08

Daniel A. White

192k49 gold badges389 silver badges472 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:29:35Z

2

From this answer

char(13) is CR. For DOS-/Windows-style CRLF linebreaks, you want char(13)+char(10), like:

'This is line 1.' + CHAR(13)+CHAR(10) + 'This is line 2.'

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Apr 11, 2011 at 17:07

Homam

23.9k37 gold badges121 silver badges189 bronze badges

Comments

Akram Shahda · Accepted Answer · 2011-05-22 15:34:30Z

1

Use CHAR(13)

Refer to: CHAR

edited May 22, 2011 at 15:34

answered Apr 11, 2011 at 17:09

Akram Shahda

14.7k5 gold badges46 silver badges67 bronze badges

Comments

moi_meme · Accepted Answer · 2011-04-11 17:12:27Z

0

its best to use System.Environment.NewLine

answered Apr 11, 2011 at 17:12

moi_meme

9,3474 gold badges48 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to insert new line to nvarchar using c# code

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related