Suggestion on keeping rtf.rtf in sql db

[yousufkhan]

Need your suggestion on keeping RichTextBox.rtf (rtf proerty RichtextBox) in slq table
so that i can save rtf data and retreiw back from sql table in same formt like bold underline and etc.. for a multi user environmet

1. Is it good to keep like this instead of rtf text will it be reliable to insert RichtextBox.rtf

2. Is there any problem to slq database for size etc..

3. I am using text field at present what should i use

Please suggest

[brucevde]

The answer depends on which database and which version. SQL Server 2008 introduces a new method to store Blob data. Basically, you define the field as varbinary(max) or varchar(max) and give it a FileStream attribute. SQL Server 2008 then stores the actual file in the FileSystem but applications can still use typical t-sql statements to insert/update the data. With SQL Server 2005 the data is stored in the database file.

[yousufkhan]

I am using sql server 2000

[dee-u]

Since you are already using text to store it, are you currently having problems with it?