I am capturing user comments in a textarea field on a web form and then storing the comments in a text column in a DB table. I would like to know if the carriage returns and linefeeds get stored in the database (MS SQL 2000)?
CREATE TABLE myTable99 (col1 varchar(8000))
DECLARE @x varchar(8000)
SELECT @x = 'Wasted away again in
INSERT INTO myTable99 (Col1) SELECT @x
DROP TABLE myTable99