On 2019-02-18 15:50, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
My VFP9SP2 app connects to my web database with no issue. My client wanted to host the database on his network there so I installed MariaDB there and everything seemed to fire up just fine. HOWEVER, there's a problem with the memo fields capping at length=255. Given that it works with a different (my web) MariaDB database, I'm sure this is a configuration issue. Question is: where do I find/set that?
His network OS is Windows 2016 Server. My web database is using a Linux OS iirc.
tia, --Mike
Here's the weird fix: instead of using a MEDIUMTEXT field, it worked just fine when I changed it to TEXT fields. Now MEDIUMTEXT is supposed to handle LARGER #s of characters, but in this case, just TEXT should suffice.
Still...wonder why the ODBC (originally 3.51, then I upgraded to the latest 64-bit MariaDB driver) has a problem with MEDIUMTEXT on this Windows 2016 Server? My other database (where no issues at all) operates on a Debian Linux OS.
Thoughts?