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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c1aed83f-58f7-4783-91dc-07e8a0f4179a.png)
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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1f17f3d1-2ff2-45f9-a1da-efc4effe06c5.png)
The database:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c8947805-f100-4453-9ff0-23c965d0271d.png)
The table:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/71176320-e3d2-4763-a07e-324a2eb04569.png)
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
Best answer by Freeman Helmuth
View original