>Our experience is that getting a Memo field for any of the TEXT types depends on the length of the longest field returned. If it is > 254 you will get a Memo field, otherwise you get a Character field with an unpredictable (depends on data returned) length.
>
>The exception to this is that VARCHAR(>= 255) always returns a Memo field, regardless of the actual length of the data. Consequently, we've made all the memo fields VARCHAR() and check the length prior to saving to make sure we don't get a "Length exceeded" error.
>
>I can't be sure this applies to your environment as well, just hope it helps
>
>.......Rich

Rich,

Thanks for the reply.

I started playing with the flags on the MySql ODBC connection I had made to the database. I set the flag 'limit column size to signed 32-bit range' and this seemed to work. Memo fields with large amounts of text are being retrieved properly now.

Mike