I am getting this error when creating a new instance, any idea how to resolve it is much appreciated.
Answer
Acumatica and MySQL - Illegal Mix of Collation Error On Instance Creation
Best answer by emeldamakamba
I managed to get a workaround from Acumatica Support team which is working fine for now.
+8Please test and if you still have any issue submit a support request with details.
SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
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.
Emelda ~ A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Hi
I managed to get a workaround from Acumatica Support team which is working fine for now.
Emelda ~ A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Hi
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.
We had to manually add the following in the .ini file - please see attached full version of the file in text format:
Emelda ~ A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.