Skip to main content
Solved

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


emeldamakamba
Jr Varsity II
Forum|alt.badge.img

I am getting this error when creating a new instance, any idea how to resolve it is much appreciated.

 

 

Best answer by emeldamakamba

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

View original
Did this topic help you find an answer to your question?

7 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 195 replies
  • June 13, 2022

@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.

 

 


emeldamakamba
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • June 14, 2022

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.

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • July 25, 2022

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


emeldamakamba
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • Answer
  • July 26, 2022

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


Forum|alt.badge.img
  • Varsity I
  • 63 replies
  • June 14, 2023

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.

 

 


emeldamakamba
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • June 15, 2023

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

 

 


Forum|alt.badge.img
  • Varsity I
  • 63 replies
  • June 15, 2023

Thanks


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings