Acumatica and MySQL - Illegal Mix of Collation Error On Instance Creation

Thanks

We had to manually add the following in the .ini file - please see attached full version of the file in text format:

Hi @emelda71,

Just wondering if you would mind sharing what the workaround the Acumatica support team provided was?  We have the exact same issue and the above says that there was a workaround but doesn’t say what it was.

Thanks,

JOhn.

I managed to get a workaround from Acumatica Support team which is working fine for now.

Hi @emelda71 - were you able to find a solution for your issue? Thank you!

Thanks for the response.

I am using 2022 R1 Build 22.106.0015 (which is currently the latest).

I have already submitted a support request and the issue is currently with Dev.

@emelda71 Not sure what version of Acumatica you are using but I am aware this issue has been reported and fixed in 2022R1.

Please test and if you still have any issue submit a support request with details.