How to add paragraph in sql column

The first thing is, what do you actually mean by paragraph?

When you pass the data to the SQL Server (Pardon me if you're using any other data source; like MySQL, MS Access etc), it stores that data in nvarchar (or what so ever data type you've provided to that column) any new line entry is also preserved. So when ever you're going trying to enter the data to the SQL Server's column, it would store the data as it is and will return the data as it is.

If you're not getting the data back, as it was sent to the SQL Server, you might try to check if there is any code that is removing the new line character (sometimes \n and sometime \r\n). If this is ASP.NET, you might also want to try using Html.Raw() to convert the string data returned from the database to the HTML markup. If you're using any other framework (like WPF, or Win Forms) then you might want to use their specific codes like covert to Unicode etc.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Afzaal Ahmad Zeeshan11y ago
The first thing is, what do you actually mean by paragraph?

When you pass the data to the SQL Server (Pardon me if you're using any other data source; like MySQL, MS Access etc), it stores that data in nvarchar (or what so ever data type you've provided to that column) any new line entry is also preserved. So when ever you're going trying to enter the data to the SQL Server's column, it would store the data as it is and will return the data as it is.

If you're not getting the data back, as it was sent to the SQL Server, you might try to check if there is any code that is removing the new line character (sometimes \n and sometime \r\n). If this is ASP.NET, you might also want to try using Html.Raw() to convert the string data returned from the database to the HTML markup. If you're using any other framework (like WPF, or Win Forms) then you might want to use their specific codes like covert to Unicode etc.