Error setting up ODBC connection to Powerbuilder 7.0

[Anne-Marie Matula]

Hi,
I set up a 32 bit ODBC connection to MySQL Server within Powerbuilder 7.0. I tried both ANSI and Unicode and received this error in both when I ran a select * on a table in Powerbuilder

Select error: SQLSTATE 22018
[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.24-log]

The error with a select * results in not all records being extracted.

I identified the culprits where the error is triggered, a varchar[500] field and a mediumtext (containing JSON) field.

So if I select all but those 2 fields all records are extracted.

I looked at the data and do not see what is causing the problem.

Interesting querying in DESC order extracted nothing:

select id, displaydescription from actions
order by id DESC;

Does anyone have any idea what the issue can be?

I appreciate your time and help!
Annie