Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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.

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

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...

Thanks for the info but the 8.0.31 did the same thing as the 8.0.33. The only types of fields it brings over correctly are integer and date. Populated character fields are brought over as memo and for blank character fields it shows a NULL. MySQL Server version is 8.0.35

OK, uninstalled the newer one, tried 8.0.33. I tried it on a simple table , no encoding. Same thing basically. It retrieves character fields as memo fields, bigint as character. Integer is the only that looks ok. If I get past a simple table, I will look at the STRCONV function. I was reading...

It's 8.0.42. Installer is mysql-connector-odbc-8.0.42-win32.msi Which I got from https://dev.mysql.com/downloads/connector/odbc/

I realize it's a crash. It kicks me out completely. I am in fact using the same ANSI driver you mention. The unicode driver would not even let me run the query, it would crash. When I say run the query, I am doing it from the database designer with a remote view. Have not tried coding it. As...

Trying to read data from a MySQL ver 8 DB into VFP9Sp2. I am now using an ANSI ODBC driver so no problem there, it doesn't crash but it will still not read the data correctly. Some tables have fields/columns that are encoded. It will read data from any table that does not contain any UTF8...