Re: keep the new line character in SQL server text

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Caspy (caspases_at_yahoo.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 10:46:13 -0400

Thanks,
In addition, how to make the application can handle post images? the images
should be save separately as "image" type, right?

--Caspy

"Nicole Calinoiu" <nicolec@somewhere.net> wrote in message
news:e8YKpnzPEHA.3524@TK2MSFTNGP09.phx.gbl...
> Caspy,
>
> This is very unlikely to have anything to do with SQL Server or your data
> storage. Instead, it's most likely the result of HTML display rules,
which
> preclude the rendering of extended white space. To conserve the paragraph
> formatting, you can wrap the text in a PRE element. e.g.:
>
> <pre>Your text goes here with
>
> white space
>
> preserved at rendering.</pre>
>
> See http://www.w3.org/TR/html4/struct/text.html#edef-PRE for the official
> word on the PRE element.
>
> HTH,
> Nicole
>
> "Caspy" <caspases@yahoo.com> wrote in message
> news:OsP8KOzPEHA.628@TK2MSFTNGP11.phx.gbl...
> >I am developing a web site for a discussion forum with SQL server 2000 as
> > back end data storage. The post messages are save as 'text' in database.
> > Messages are extracted from a text box. In the text box, poster can have
> > some format like new paragraphs to make post look better. However, the
> > message from the SQL server lost all new line characters. each message
is
> > long string with any line break. How to keep the paragraph format?
> >
> > thanks,
> >
> > --Caspy
> >
> >
>
>

Relevant Pages

  • Re: [fitsbits] Question(s) regarding development of proprietary FITS manipulation software. . .
    ... mandatory keywords which appear in ANY header ... by sub-type I mean here the various kinds of extensions: ... I'll then add that is an old format, now deprecated, and used ... In most cases of the 2-d images they are sky images (and data cubes ...
    (sci.astro.fits)
  • Re: How to convert into jpeg bitmaps that were copied over from Pa
    ... Thank you for insisting on this point (format of embedded data stream) I was ... Since you say that in both cases Word stores jpeg data streams, ... the images you've pasted into Word are already in jpeg format. ...
    (microsoft.public.word.drawing.graphics)
  • Re: Word 2007 produces very large Word 2003 compatible files
    ... If you turn it on the default for all new documents will also save a preview picture. ... I don't have access to Vista right now to give you the exact wording but it's along the lines of "Always save preview thumbnail". ... Mainly this is because the thumbnail is saved as a small graphic in the ZIP package instead of the large embedded image (sometimes 2 images depending on the image file type) saved in the old file format. ...
    (microsoft.public.word.application.errors)
  • Re: XDepth Raw: a jpeg-compatible Raw compressed format for digital cameras
    ... Uncompressed HDR images are generally 96bpp images. ... but I'm not trying to advertise 8bpp for HDR. ... is an ISO standard, you can make sure that you get your images back even ... The same cannot be said with your format. ...
    (comp.compression)
  • Re: EDD Plus Project
    ... emulator writers won't support a new format unless it is very easy to ... generate the new images. ... Apple II emulator that supports it. ... What do FDI stand for? ...
    (comp.sys.apple2)