>Hello All,
>
>I am creating a VFP6 application with and Oracle8 backend database. This database will be used to manage usernotes. In the past I have used memo feilds to hold these notes. I notice that Oracle supplies a 'CLOB' field type. I believe that this will be the closest thing to VFP's Memo field. I have heard some mixed comments as to the use of this field type. Could anyone offer any input or alternatives?
>
>Matt

I use a LONG data type for memo fields. You can only have 1 of these per table and their capacity is 2 GB per ROW. The CLOB [Character LOB] data type can be used multiple times in the same table. LOB columns usually store locator values that point to data locations and not the actual data or object. So you definitely have some issues in using these for memo fields. IMO, they are not really appropriate for VFP memo fields. You should use the LONG data type for character data and LONG RAW for binary data.