Re: MariaDB limitation on memo fields -- caps out at 255
On 2019-02-18 18:07, Fred Taylor wrote: Mike, Are you sure it's not a TINYTEXT field? TINYTEXT is 0 to 255 chars. TEXT is 65,535 And MEDIUMTEXT is 16,777,215. Fred I'll double-check but I'm thinking it's my connection string OPTIONS value. ___ 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/64a6e2b22c31b10dba7d051fcc6c1...@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.
Re: MariaDB limitation on memo fields -- caps out at 255
Mike, Are you sure it's not a TINYTEXT field? TINYTEXT is 0 to 255 chars. TEXT is 65,535 And MEDIUMTEXT is 16,777,215. Fred On Mon, Feb 18, 2019 at 1:48 PM 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 > [excessive quoting removed by server] ___ 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/cajcbkspcma+4hwslqklc6yzoxdbf-mgfohx74wruujk7t0u...@mail.gmail.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.
MariaDB limitation on memo fields -- caps out at 255
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 ___ 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/497fb3eb15f3d608fb2d07fc0e4f1...@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.
Re: SFTP
On 2019-02-08 06:09, Chris Davis wrote: Me again, sorry! I have been using vfpconnection for sometime now, very useful! However I have now got a ftp server that I wont connect to. The url I have been given starts SFTP, vfpconnection only seems to support FTPS. When I use FTPS I just send up with a SSL error when tracing it through. Should I be looking for another solution that maybe supports newer protocols or am I missing something? Thanks Chris. Hi Chris, I used a simple solution from Dave here. Let me know if you still need something. --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/aa0810cf0104098004124dbc06e56...@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.