Hi there, I have been recently been getting some errors for some of my queries I am performing with the JS backendless sdk. These errors appear at random - sometimes the queries are executed normally, while other times I get the error. This is very bad for our production environment.
These queries have been working for a year, but suddenly I am receiving this error:
Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '<>'
const queryBuilder = Backendless.DataQueryBuilder.create(); queryBuilder.addProperties('objectId', 'name', 'description', 'email', 'phoneNumber', 'website', 'street', 'city', 'zipCode', 'picture', 'logo', 'openingHours', 'mapsIframeLink', 'geolocation', 'url');
const promise = Backendless.Data.of('Provider').find<Provider>(queryBuilder);
Thanks for your help