SQL Server - HTML <BR><BR> corrupting CSV output
Posted on 2013-06-03
I have a table that contains a column nvarchar(max) that contains text that includes <BR><BR> in the value.
When I save query results in CSV or Tab delimited format, the rows become corrupt at the <BR> characters.
What are my options for dealing with this? Is there any way to preserve these HTML characters in the CSV output withoiut corrupting the file?
Thanks in advance.