MySQL Forums
Forum List  »  Newbie

MySQL return empty results when TEXT field is included
Posted by: John Peter Paredes
Date: August 28, 2018 10:20PM

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 ?

Options: ReplyQuote

Written By
MySQL return empty results when TEXT field is included
August 28, 2018 10:20PM
August 29, 2018 08:21AM
August 29, 2018 08:26PM

Sorry, only registered users may post in this forum.

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.