LOTUS CONNECTORS

Processing Attachments Stored in Rich Text Fields
Notes is primarily a document management system -- not a relational database management system (RDBMS). Because of this, Notes performs special handling for attachments stored in Rich Text fields. It stores the attachment data separately from the Rich Text field data. Currently you can only transfer attachments from Notes to Notes; Rich Text fields with attachments do not store correctly in the target RDBMS's such as DB2 and Oracle.

To work around this constraint, you can use the Notes Connector Extract File Attachments option to save attachments to files on disk. You can then use LotusScript to read the files, store their contents in LCFields, and save the LCFields to binary fields in a RDBMS. This level of scripting requires LotusScript expertise.