Post reply

no new raws in insertedtext

  • July 26, 2008 at 4:01 pm

    #188590

    Hi everybody,

    I am using sql server 2005 express and windows server 2003.

    I am using usual insert command to insert a text into a table with a column which is ntext. I have used enter key to make new lines in my text when i inserted it to the table but when i browse to another page (on my web site) the text is only one single line.

    i am using following code to show the text.

    thanks for your help

  • July 26, 2008 at 6:51 pm

    #848835

    This isn't likely a SQL issue, but a display issue. SQL Server does not remove CHR(13) from your text if you insert it with those characters in there. It is up to the client to then display things properly.

    HTML does not start new lines with a CHAR(13), only a br or p tag will start new lines.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply