Hi

 

The square things are just enterprise managers way of showing CR and LF. What other apps are you trying to use the data in?

If you do a select statement in sql manager and show the results as text, does the text look properly formatted? It should do...

 

When saving and retrieving from the database I dont do any encoding/decoding. I just send a string and get a string and its all shown fine.

 

You may want to consider using NVarchar instead of Varchar because this then means you can store characters outside the standard ascii range e.g. different character sets or symbols. But these will still be shown as squares in sql manager.