Funky Line feeds in MS SQL

Question

When I inserted text from one SQL Server VARCHAR(MAX) field in one database to another, I get question mark symbols - "?" - in the target database (in addition to line feeds) whenever there are line feeds in the source database.

Text in the target database looks like this:

Line one.?
?
Line two.?
?

Any ideas about what could cause this, and how to fix it?

Answer 1

Do both databases have the same collation? Perhaps they use different encoding and when you pasted it gave you such weird results?