MySQL return empty results when TEXT field is included
Im having issues with MySQL 8.0 and Visual Foxpro 9.0 SP2
before i had MySQL 5.0 and when i query a table that has a TEXT field i get results.
Given : d_date is datetime d_remarks is TEXT
=sqlexec(myhandle, "Select d_date,d_remarks from SampleTable" ,"SampleCursor")
Now on MySQL 8.0 the same query above would return EMPTY result. i had to remove d_remarks from the field list so
that it would return the actual rows.
=sqlexec(myhandle, "Select d_date from SampleTable" ,"SampleCursor")
but i needed that field column :( .. can you please help me what is going on ?
Subject
Written By
Posted
MySQL return empty results when TEXT field is included
August 28, 2018 10:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.