#1267 - illegal mix of collations

We received the below notification when trying to debug a view, we were not able to export or anything with this error up. The error occured in our UAT environment and this view hasn't been changed in months, all other environments remained unchanged:

I cannot find a reason why this view would fail in only this environment, i have checked the tables and they have also not been changed collation type. Any thoughts much appreciated? 

  Discussion posts and replies are publicly visible