Question

Differentiate between o l e object and memo data type

Answer 1

Answer:

Memo data type

• The MEMO data type provides storage for variable length and arbitrary format data. A MEMO field can contain either text or binary data.
• There are two synonyms for the MEMO data type: CLOB and BLOB.
• A CLOB (character large object) is specifically defined for text.
• A BLOB (binary large object) is specifically defined for binary data.
• A MEMO/CLOB/BLOB field cannot be a KEY.
• A MEMO/CLOB/BLOB field can be in a TEMP table.
• The maximum MEMO/CLOB/BLOB field size is 262,144 bytes.
• In the data base, a MEMO field is represented by a 20 byte marker. The size of the marker is defined by the symbolic constant TBAPI_INTERNAL_MARKER_LENGTH in ddl_defs.h.

OLE object data type

• The OLE Object data type allows you to store complex data, such as pictures, graphs, or sounds, which can be edited or displayed through a dynamic link to another Windowsbased application.
• For example, Access 2010 can store and allow you to edit a Microsoft Word document, a Microsoft Excel spreadsheet, a Microsoft PowerPoint presentation slide, a sound file (.wav), a video file (.avi), or pictures created using the Paint or Draw application.
• Data size upto 2 GB.

Answer 2

Answer:

ole and memo

Explanation:

OLE IT STORES THRE DATA FROM OTHER SOFTWARE LIKE WORD EXCEL ETC

MEMO DATA TYPE THE MEMO DATA TYPE PROVIDES STORAGE FOR VARIABLE LENGTH AND ARBITRARY FORMAT DATA A MEMO FIELD CAN CONTAIN EITHER TEXT OR BINARY DAT