Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gguerra

  1. gguerra

    Reading MySQL 8 encoded data into VFP9

    Give up on me? Go ahead and give up. All you are telling me is to ignore it, the software uses the bytes for whatever it wants to use it. Really? I need to use it outside of the software and yes HUMANs are reading it. I never said the data was not ok or corrupted or whatever, that is OBVIOUS...
  2. gguerra

    Reading MySQL 8 encoded data into VFP9

    This gave me a Syntax Error in workbench. Image attached. Still looking into this. I did not do it in Excel or VFP. I did open up the blob field in workbench from the previous query and yes, you I get hex. I assume I will get hex in VFP if I define a shorter field first but I get a memo which...
  3. gguerra

    Reading MySQL 8 encoded data into VFP9

    I did not even attempt to do the CA, this (above) worked and brought it in as character. I even went as far as reducing the size to 40 instead of 240. I tried it one field at first, I can just go ahead and do it for all of the fields that I need that are defined as varchar(255). I made the...
  4. gguerra

    Reading MySQL 8 encoded data into VFP9

    I deleted my previous reply by mistake but here it is in a nutshell. I ran the queries to convert to binary. I attached the images of the results in VFP, Workbench (BLOB) and Workbench with the option checked ON to show binary as nonbinary which still shows binary data. Still confused, it...
  5. gguerra

    Reading MySQL 8 encoded data into VFP9

    Fairly obvious I think. I would like to be able to read what is there in plain English. Why does Excel decode it in the preview and not in the result? Off topic or maybe not? I'm still at a loss as to why it's encoded at all, anywhere. No encoding appears in Workbench at all, only on the client...
  6. gguerra

    Reading MySQL 8 encoded data into VFP9

    I can't answer what the list goes on with, that would come up for sure with time. Memo fields are exactly that, memos, free form text, not structured character fields. It's like a notepad. I use grids a lot, memo fields are not ideal for grids, require an extra click or key press just to view...
  7. gguerra

    Reading MySQL 8 encoded data into VFP9

    Chriss.. Maybe bringing over VARCHAR(255) as memo fields is the "correct" behavior and yes the data is there inside the memo fields and yes I know capitalized memo fields contain data. I just can't use memo fields the same way I would character fields. I cannot manipulate them the same way, I...
  8. gguerra

    Reading MySQL 8 encoded data into VFP9

    I had the same thought myself but... Did MySQL ver 5 not have the same formats? And even though I cannot confirm it, it is reported to work correctly. I have no experience with variable length character fields, so I googled it. This is what AI came back with. You would also think that the...
  9. gguerra

    Reading MySQL 8 encoded data into VFP9

    Chriss.. There is a table in the DB called 'projects'. Here are the columns straight from Workbench. I've attached some images. The first is the structure from MySQL, the second is the query results on that table from MySQL and the third is the table as it comes into VFP. You can see exactly...
  10. gguerra

    Reading MySQL 8 encoded data into VFP9

    It says MySQL 8.0.35 on the main screen of Workbench, I ran a query to check.
  11. gguerra

    Reading MySQL 8 encoded data into VFP9

    I guess I missed the part of ME using the MariaDB connectors. I tried it and unfortunately, the exact same results. I suspect this system does use the MariaDB connectors as there was already a DSN entry for MariaDB which I did not install. It's part of their install. I have no idea why they...
  12. gguerra

    Reading MySQL 8 encoded data into VFP9

    I am at the starting point. I am only trying to connect to MySQL via the database designer. No PRGs, no code, no point yet. On a related note, my experience is with Microsoft SQL Server. I am new to MySQL. Same basic principles, different platform. I see it mentioned but I am not familiar with...
  13. gguerra

    Reading MySQL 8 encoded data into VFP9

    Tried the Devart driver, same exact results as the free one unfortunately. As far as the ones from MySQL, the earliest 32 bit driver is 8.0.12. 8.0.11 is only available as a 64 bit version. Same results. At this point there is not much hope except for the one I am waiting on.
  14. gguerra

    Reading MySQL 8 encoded data into VFP9

    I went back to look here. The driver version is 5.2, My mistake and bit confusing on their end imo. https://www.devart.com/odbc/mysql/download.html I will try it. I will get back to you. Thanks
  15. gguerra

    Reading MySQL 8 encoded data into VFP9

    I will try the earliest 8.0.x driver and get back to you. The 3rd party driver I am going to try is from this company. It's expensive at $300 a year but if does what I need, the company can afford it. https://www.cdata.com/odbc/ I installed it and when I tried configuring the connection, it...
See more

Part and Inventory Search

Back
Top