LOTUS CONNECTORS


Processing RTF Fields Between Notes and RDBMS
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.

Notes rich text fields are stored in a proprietary binary format. For example, Notes rich text data written to Oracle fields will result in the Oracle fields containing data in that proprietary format. Non-Notes applications will be unable to process this data. Notes rich text data is not the same as Rich Text Format data used for word processing documents.

In order to use BLOBs or RAWs, they must first originate in Notes, be inserted into the Oracle table, and then be read back into Notes. Otherwise, the BLOB or RAW data will not be in a format that Notes can recognize. This is also true for LEI and DECS when a Notes database is one of the connected databases.

For all non-Notes Connectors, if you move data into a Notes rich text field and then read it as type binary, that binary data will then be in Notes rich text format.

Using a Notes Database as the Source

Binary data transferred from a Notes source will act as shown in the following tables.
Binary DataNotes Destination
as binarywill be stored in Notes Rich Text format
as textwill be stored as Text
Binary DataNon-Notes Destination
as binarywill be stored in Notes Rich Text format
as textwill be stored as Text
Non-binary DataNotes Destination
as binarywill be stored in Notes Rich Text format
Non-binary DataNon-Notes Destination
as binarywill be stored in Notes Rich Text format

Using a Non-Notes Database as the Source

Binary data transferred from a non-Notes source will act as shown in the following tables.
Binary DataNotes Destination
as binarywill be stored as Notes Rich Text format (but source may or may not be Notes Rich Text)
as textwill be stored as Text
Binary DataNon-Notes Destination
as binarywill be stored as binary (in its original format)
Non-binary DataNotes Destination
as binarywill be stored in Notes Rich Text format
Non-binary DataNon-Notes Destination
as binarywill be stored as binary (in its original format)