Partager via


Memo Field Type

To store data blocks of any kind, such as null values, assembler code, printer drivers, and alphanumeric text of indeterminate length, or a reference to a data block in a field, use the Memo field type. To prevent data in Memo fields from being translated across code pages, use the Memo (Binary) field type.

Tip

To create a Memo (Binary) field, use the NOCPTRANS option in the SQL CREATE TABLE and CREATE CURSOR commands or select it in the Fields tab in the Table Designer.

Memo and Memo (Binary) fields contain a ten-byte reference to the actual contents of the memo. However, the actual size of memos depends on the amount of data you store in them. Data from Memo and Memo (Binary) fields from records in a table are stored in a separate file with the same name as the table and an .fpt file name extension. Memo and Memo (Binary) fields are limited only by the amount of available disk space.

You can store contents of Memo fields as memory-resident strings. You can then manipulate these strings with all functions that operate on character data.

For specifications about the Memo and Memo (Binary) field type, see Visual FoxPro Data and Field Types.

See Also

Tasks

How to: Choose Data Types

Reference

CREATE TABLE - SQL Command

Fields Tab, Table Designer

MODIFY MEMO Command

Other Resources

Data and Field Types