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