DataTable cell contains line breaks while SQL table doesn't

Asked Mar 15 '22 at 12:56

Active Mar 15 '22 at 13:13

Viewed 13 times

I've been using the same simple function to return data from SQL for years and I think this is the first time I'm experiencing this. I've checked the SQL table, copy pasted the cell into Notepad++, displayed all characters and there's only spaces between words, nothing special. The column is of type nvarchar. But when I retrieve the table with DataAdapter many of those lines break and when I copy paste those into Notepad++ it's clearly CRLF. See attached image. Lines 1 & 2 are from the Visual Studio Data Table Visualizer as soon as I get the table. Line 4 is straight from SQL query Result. I'm using the same query both times.

What could be the reason for this? Been looking for hours, can't see what I'm missing.

asked Mar 15 '22 at 12:56

okkko

1,010
1
13
22

If you're using SSMS, you did enable Retain CR/LF on copy or Save, right? – Thom A Mar 15 '22 at 12:58
@Larnu where's that? – okkko Mar 15 '22 at 12:59
@Larnu found it (Query - Query Options)! OMG. I think in the past it was turned on by default. Thanks! – okkko Mar 15 '22 at 13:01
Tools -> Options -> Query Results -> SQL Server -> Results to Grid -> Retain Cr/LF – Charlieface Mar 15 '22 at 13:01
Does that fix the issue? – Charlieface Mar 15 '22 at 13:01
@Charlieface YES, because now I can see the problem is indeed in the raw (SQL) data. – okkko Mar 15 '22 at 13:02

DataTable cell contains line breaks while SQL table doesn't

0 Answers0