Best format to store for web app

Hi Brendan,
I am thinking of using the FTC to collect user information via a OSX and Win32 RB client app. 
The info will be stored in a database (perhaps after I BASE64 encode it)
What I was wondering, would it be better to store the FTC info in the db as XML and then when I need it, transform that XML into RTF (when I print from the RB Clients) or XML-HTML when I access the data from a Web browser accessing the same info in the same central db.
Or is it better to store it as RTF in the DB and transform RTF-> HTML when required?
I seem to be leaning towards the XML in the DB, as XML->HTML and XML->RTF (and XML->PDF) are reasonably well-known transformations. Which would you use? 
--

Cheers,

Dr Gerard Hammond
MacSOS Solutions Pty Ltd
macsos@xxxxxxxxxxxxx  http://www.macsos.com.au

Proofread carefully to see if you any words out.

FTC Website: www.truenorthsoftware.com/Realbasic/FormattedText.html
Set List Options (digest and vacation modes): www.freelists.org/list/ftcdev
List Archive: www.freelists.org/archives/ftcdev
Unsubscribe: Send email to ftcdev-request@xxxxxxxxxxxxx with "unsubscribe" in 
the subject field.

Other related posts: