We're having the issue described below with Acumatica and cannot find a solution. We have an open ticket and Acumatica support has been sporadically working on it for several weeks now but no answer. They can't reproduce it and so have done a screen share to look at it on my machine, but to no avail. Posting here in hopes that someone can help
We've tried a fresh install on other computers and get the same error.
Environment:
Acumatica 2021 R2
MySQL 8.0.26 Community on Windows Server 2019 Standard
When adjusting the column width of a GI, the following error message is thrown:
I have tried various combinations of charsets on the database to no avail. I have also tried different column types with the same result
Here is the database character setup:
The database:
The table:
This Stackoverflow article may shed some light:
https://stackoverflow.com/questions/37062643/incorrect-string-value-mysql-issue-when-inserting-utf8-text-into-a-latin1-col
