As Razzak posted earlier: Dan,
VARCHAR is the ideal data type to store RTF or Plain Text beyond the limit of 4096 characters. Take a look at the R:Docs for sample table and examples. While using the data in reports, make sure to use Advanced DB Rich Text control to take advantage of formatted text and all advanced features. Very Best R:egards, Razzak. Sent from my iPhone -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Marco Groeneveld Sent: Monday, August 23, 2010 1:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - re: uploading .doc in rbase Razzak, What is the best varchar or varbit ? Which format (.rvf or .rtf) is used to save the content in R:BASE ? I am able to open .rvf and .rtf files in R:BASE BLOB Editor I am able to export to .rvf, .rtf file in R:BASE BLOB Editor. Maybe it is nice to have open or import .doc and .docx files and automatic save it as .rtf in R:BASE in a future build ? Marco ----- Original Message ----- From: "A. Razzak Memon" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, August 23, 2010 5:19 PM Subject: [RBASE-L] - re: uploading .doc in rbase > At 10:34 AM 8/23/2010, Luc Delcoigne wrote: > >>in my Access > Rbase conversion I have come to the point that >>I have to load .doc files into the varchar field of an rbase >>table. >> >>What would be the most elegant way to this, considering there >>are more than 80.000 files to upload in the table....? > > Luc, > > Here's how I have converted/stored all .doc files into R:BASE. > > 01. Open the original .doc file(s) in MS Word and then save as > .RTF to preserve the original formatting, etc. > > 02. Then, load these .rtf file(s) in R:BASE as VARCHAR or BLOB > (VARBIT) data type. > > Use the appropriate data type (VARCHAR/VARBIT) accordingly. > > 03. Once stored in R:BASE, you may take advantage of enhanced > Blob Editor to manage all your documents, etc. > > Tip: > > When using the enhanced R:BASE BLOB Editor, make sure to > select [Rich Text] option/tab to manage .rtf files. > > 04. To print these documents in R:BASE eXtreme 9.0 reports, > make sure to use Advanced DB Rich Text Control. > > That's all there is to it! > > 2010 Annual R:BASE Conference Highlights include a session to > demonstrate the use of such features in R:BASE eXtreme 9.0. > http://www.rbase.com/conference/ > > Very Best R:egards, > > Razzak. > >
