>>>>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.

I'm not sure how CAST would work even if VFP 9. It's something I would do after the cursor has been downloaded. I can fudge the same thing in VFP 8 if I need to.

Thanks for your help......Rich