Correct way of storing custom text wrapped with styles - Database or Text File?

lut

New Member
I am running ASP.NET connecting to a SQL Server 2005 database.Currently all my data get's saved in the database but when I use my HTML editor control (to allow the user to add styles to the text) sometimes I get the following error when I copy text with lots of styles from another website into the text area (error comes up when data is trying to save to database): \[quote\] String or binary data would be truncated. The statement has been terminated.\[/quote\]Why is this and how do I handle this? Save the text rather to a text file?The size of the field in the database is big enough!Edits\[code\]INSERT INTO TableName(Name, Age, Comments) VALUES (@Name, @Age, @Comments)\[/code\]Then from my code behind I simply call my SQLDatasource like so\[code\]SqlDataSource.Insert()\[/code\]
 
Top