At 05:13 PM 12/13/2015, Bruce wrote:
Am thinking of extracting individual emails into
.EML (ASCII text) files, storing in R:BASE.
The primary purpose is text string search;
preserving visual formatting is not important.
Which data type would be more suitable: VarChar or BLOB?
For R:BASE eXtreme 9.5 (64), use VARCHAR.
· Holds alphanumeric data
· No length is needed
· Is ideal for storing large text data
For R:BASE X Enterprise (Version 10), use BSTR.
· Holds binary string data
· Used to support Unicode in table data
· Composite data type that consists of a length
prefix, a data string, and a terminator
· Specific to R:BASE X Enterprise
Very Best R:egards,
Razzak
