Clever Geek Handbook

Funky Line Channels in MS SQL

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

The text in the target database looks like this:

Line one.?
?
Line two.?

Any ideas on what might do this and how to fix it?

+1


source to share


2 answers


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



+1


source


How do you insert data and how do you read data?

If you have different sorts, you can use the method (or out of) as needed.
http://msdn.microsoft.com/en-us/library/ms179886.aspx



Also you can check the quality and source of the data. You might need to clean up special characters.

+1


source






More articles:


All Articles