Is there a database which supports richtext features ?

Question

Is there a database which supports richtext features ?

Madhu-207721

SSC Journeyman

Points: 85
More actions
July 21, 2011 at 8:21 am

#240199

Dear,
Is there a database which supports richtext features ?
Scenario: I have a word template document with bookmarks.
I have database which stores the data for the bookmarks and other meta data.
Based on the data/record bookmarks is reterived, combined with the template and generated a word document (using aspose) and is output to the end user.
I would like to avoide the template document, However i would like to have the formats (Like bold, Underline, italic...) which are available in the template.
I would also want to have a rich text features (Bold, Underline..) stored in the database. (Example this posting message have features like bold, underline, color, :-), EmotIcon, spell Check...are they stored in the database?).
Are there any features in SQL2008R2 which fulfills the above requirements?
Is there a way to achive the above objectives? and which database supports these features.?
Is this "post new topic information" stored in the SQL 2008 R2 Database ?
Thanks
Madhu

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

Madhu-207721 (7/21/2011)
Dear,
Is there a database which supports richtext features ?
Scenario: I have a word template document with bookmarks.
I have database which stores the data for the bookmarks and other meta data.
Based on the data/record bookmarks is reterived, combined with the template and generated a word document (using aspose) and is output to the end user.
I would like to avoide the template document, However i would like to have the formats (Like bold, Underline, italic...) which are available in the template.
I would also want to have a rich text features (Bold, Underline..) stored in the database. (Example this posting message have features like bold, underline, color, :-), EmotIcon, spell Check...are they stored in the database?).
Are there any features in SQL2008R2 which fulfills the above requirements?
Is there a way to achive the above objectives? and which database supports these features.?
Is this "post new topic information" stored in the SQL 2008 R2 Database ?
Thanks
Madhu

don't confuse data storage with presentation. you can store an actual binary file in your database, and extract that file back so that the pproper application can open it.

so if you store a word file in the database, then you can extract it again, open it in Word and use the functions of word like spell check, etc on the file, and then resave the file back to teh database.

i think you are asking for a tightly integrated storage and presentation(likeSharepoint?) to handle that for you.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 2

Lowell is correct. The storage isn't related to how you view it. A word file is an XML file these days, just interpreted by the Word application.

You can store rich text, IIRC, in a varchar(max) field. The same may for Word files. If they don't fit there, store them in a varbinary(max) field.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Pileing onto the bandwagon..

Just from the subject I was guessing what was being asked.. And Lowell and Steve are absolutely right. Storage and presentation are completely unrelated, and nearly every single prominent database out there can handle the storage aspects of this. The presentation of the data is left to your app, or perhaps SharePoint..

CEWII