How to store large character data in MS SQL server ???

[Robert Liberman]

I am developing a simple ASP based form, that stores user info in MS SQL server. I have created a table in the SQL server to store the data and defined the body field with this line: `body char(255)`. The problem is that if the user inputs a string longer then 255 characters it gets choped off. How would you suggest solving this problem? Should I use `text` datatype instead?? Any comments are very appreciated !!!

Use 7.0. It allows you 8000 char for string.

[Ninel Roytman]

Probably it`s not the best solution but may be
you could create 2 or more fields varchar(255)
each to hold user input. So every row will have
fields:
field1, field2, field3.....
When you have to show this data you
can concatenate those fields so they look like
one single (field1 + field2 + field3)
Ninel