Generally, use varchar for character-based objects such as RTF and varbit for bit-based objects such as photographs, graphics, etc.
Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Marco Groeneveld Sent: Monday, August 23, 2010 13:20 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. > >
