VFP 9 Select from MySQL Binary
Posted on 2012-09-01
Hi all. I have been trying unsuccessfully for around 12 hours to select data from a mysql database into my fp program. This is something I do all the time and it has always worked great.
The problem here is that I've never dealt with a db that stores all the data as binary.
No matter what method of select I use my result shows all fields as empty Memo.
I've tried everything from Convert on the mysql side to Cast on the FP side and each and everytime the same result - empty memo fields.
If I run the exact same queries and simply change the db name to one that is not stored in binary the results are perfect.
I'm assuming that I'm not the first person that's ever needed to grab some mysql data stored in binary format so there must be a way.
Can anybody here give me some pointers? I'm about ready to start pulling my hair out and I've got very little left as it is...
Some things I've tried:
CONVERT( on the mysql side
CAST on the FP side
I've even run an sql script to change all the table properties from utf8 / collate utf8_bin to latin1 / latin1_swedish_ci
that didn't work, same empty memo results
Then I created a brand new db and copied the data (only) from the binary into my latin1 db. Still didn't work!