In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions MySQL Column Width Bug
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.
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:
This Stackoverflow article may shed some light: