I am trying to insert some data into a SQL Server table. One of the columns is a VARCHAR column with the possiblity of having some carriage return and line feed characters. The problem is that on a line that ends with a backslash followed by the carriage return and line feed characters, the backslash is being truncated. How can I preserve the backslash character?
Here is a sample. Note the "crlf" characters are the actual carriage return and line feed characters, not acutal "c" "r" "l" "f" characters.
Source:
This is a test\crlf
This is the second line.
The actual data after insert:
This is a test
This is the second line.