>>>What data type do I need to use in MySQL 5 to get a memo field in VFP. All data retrieval will be via SPT, no remote views.
>>>
>>>Thanks to all.......Rich
>>
>>http://www.perlmonks.org/?node_id=28609
>
>We set the field up as TEXT. However, if I do a SELECT which brings down an empty cursor, the result is a Character field with a Length of 0. If I bring down a record where the actual length of the data is 100, I get a Char (100) field. It is only when the MySQL data field is larger than 254 that I get a memo field.
>
>Is there any way I can set it up to always get it to come down as a memo field?

Darn, you're using VFP8. I wanted to suggest CAST approach.

I'm not sure then, sorry.