Illegal mix of collations

General
1

Hi,

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.

2

Hello @Nicolas_REMY

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

3

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.

4

Hello @Nicolas_REMY

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

5

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.

6

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

7

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

8

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?