TextAreaFor with new lines throws an inner exception

Question

It might be easy, but .....

I have a view that includes a text area: @Html.TextAreaFor(model => model.ContactInfo)

Without any new lines or with help, @Html.EditorFor

everything works smoothly. When I type in an address like ...

 John Doe
 1 Right Way
 New York, NY

... the following inner exception is thrown:

"String or binary data would be truncated.\r\nThe statement has been terminated."

How do I solve this?

+3

user5398447 16 Mar 12 at 15:59

1 answer

user5398447 · Accepted Answer · 2012-03-16T16:14:35+0000

Kurt hit a nail on the head. I only hadvarchar(10)

in this field. Stupid me.

Lesson learned: "See what a particular field can do before jumping to conclusions."