General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>Hello All,
>
>We are in the process of converting an old VFP database to MySql. I am now looking into seeing how well the data structures were converted. Any Memo field that existed in the old database was converted into a Longtext field type. The data contained in the field was transferred without trouble. But when I do any queries using the MySql ODBC 5.1, the contents are returned in a C(255) type rather than a Memo field.
>
>Is there some settings of the ODBC that I need to change? Or would this be in my VFP setting?
>
>TIA
>Mike
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only