Illegal mix of collations


These last few days, I am randomly getting some “Illegal mix of collations” errors.

Here is the error in full:

Error: Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '<>'
    at new ResponseError (sdk.js:14:833827)
    at checkStatus (sdk.js:14:836165)

I am wondering what could cause this issue.

Unfortunately, I don’t have a clear way to replicate the issue since it happens somewhat randomly when testing my application.

Thanks a lot for any support you might provide.

Hello @Nicolas_REMY

Sorry, but without steps to reproduce we will not be able to help you ((

I was afraid you would say that. But indeed, I don’t understand where it comes from, and have no clue on how to reproduce systematically.

But would you have some kind of understanding what this is about ? I don’t really get the error message. Any clue would be welcome.

Hello @Nicolas_REMY

Could you please provide your AppId and names of the container and page where you can see the error

App ID is : D7075715-5086-625A-FFAB-39C2F40FB200
It seems to happen randomly on any page, but it seems each time it’s when querying table BoatUserRoles within function setCurrentUserAndBoat, if that can help narrow it down.

could you please create a new test page with a button and in onClick logic call the function?

OK, I have done that. The page is called test-page.

When I click on the button it redirects me to another page, so I can not reproduce it, perhaps there are specific steps to reproduce it and see the error?