October 7th, 2000, 08:36 AM
Is there a datatype that will hold formatting? Ie.. if a user submits a list of items:
.. the line returns will be saved? With VARCHAR the line returns are not saved and the data returns like:
apples oranges grapes
October 7th, 2000, 08:56 AM
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.