to preserve line breaks

• RightOnTarget

  Hall of Fame

  Points: 3041

  More actions

  October 14, 2014 at 4:21 pm

  #291708

  Hi all,

  I can't seem to find a solution to the following.

  I have a front-end page where user types text and hits the button to insert it into sql server 2K8R2

  Another web tool pull this data several days later, but all line breaks are gone.

  Is there a way to store data in sql server including line breaks?

  Thanks,

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  October 14, 2014 at 4:48 pm

  #1752354

  SQL Server stores the line breaks without any problem. One of your applications must be removing the line breaks.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• RightOnTarget

  Hall of Fame

  Points: 3041

  More actions

  October 14, 2014 at 4:52 pm

  #1752355

  Thanks for reply. How can I check that?

  --drop table ep

  create table ep (text varchar(100))

  insert into ep values (

  'german

  shepherd

  dog'

  )

  select ?????

  update:

  I see it now. I redirected output to text and see that you're correct.

  So, it must be ssms issues then. Is there a way to fix that?

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  October 14, 2014 at 5:02 pm

  #1752358

  That should work but put SSMS into text output mode (press ctrl-t before running), not grid mode or you won't see the line breaks.

  It could be that your web application is just not rendering the text correctly - by default a line break does nothing on an html page.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]