On 2019-02-23 01:23, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 2019-02-18 15:50, mbsoftwaresoluti...@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?
No takers on this one. Look at the solution above. Thoughts on why TEXT
worked and not MEDIUMTEXT (which is larger than TEXT iirc)?
tia,
--Mike
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/f743075b64adf1083a3e34348960e...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
