BLOB or TEXT or ???

Is there a datatype that will hold formatting? Ie.. if a user submits a list of items:

apples
oranges
grapes

.. the line returns will be saved? With VARCHAR the line returns are not saved and the data returns like:

apples oranges grapes

TIA,
Mike

newlines ARE saved in varchar() types (and in all textual datatypes), you just aren't displaying it correctly.

Remember, HTML does NOT display new lines.

If you are using PHP as your scripting language you can use the nl2br() function to convert the newline characters in the data to <BR> so they display correctly.