Offline Editor Design ...?

[Vijay S. Rathore]

I have a typical requirement in one of my web based projects. The problem is broken into two parts:

1.The users want to store some notes/comments about a product into the database. These notes/comments are in the rtf(Rich Text Format) containing bold, italics, bullets, spell check etc. text formats. To resolve this we found out a rich text web editor that can give us bold, italics, bullets, spell check etc. features. The question is how shell we store the text in dattabase? In rtf format or in plain text format. We have to read back data for reports also.

2.The real problem is users want this to work as an offline solution also. Means they should be able to export this text and should be able to work on comments from home. Once they are back in office, they should be able to import these contents back to the application.
Whatever solution we work on should be consistent. Even the spellchecker also should be same.


What could be the best design under this scenario?

[David O'Meara]

The Programming Diversions forum is for puzzles and other stuff of general interest. This is bit specific.

I'm moving it to HTML and JavaScript, hopefully Eric knows what to do with it.

Dave