S/B EZ: Losing Carriage Returns and Line Feeds in SQL Server
Posted on 2007-04-07
Hopefully this isn't too difficult, but after searching I haven't really found a solution.
My VB.NET Windows App stores information that is input into a rich text box (a text box would be fine too) into a field of an SQL Server database. The important thing is KEEPING carriage returns and line feeds. When I pull the data back out, Carriage Returns and Line Feeds are lost. E.g.
How Are you
Have you been alright.
Comes back as:
HelloHow Are youHave you been alright.
So I need to preserve the CR's and LF's. I've read articles where they suggest replacing the CR's and LF's with the <br /> tag, but this isn't a web app, and doesn't appear to work for an Windows application.
I tried configuring the SQL field as varchar(), nvarchar(), and ntext, but there's no difference in the result.