I'm adding data to a text column, and whenever I have a backslash at the end of a line it disappears. Here's an example:
INSERT INTO MyTable (TextCol) VALUES ('some\ text
some more text\
yet more text')
Here's another example of the problem:
SELECT CASE WHEN 'a' = 'a\
' then 1 else 0 end