SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'

[rodrigocoelho]

Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'; GET /api/v1/GlobalSearch?q=rodrigo&maxSize=10&offset=0&orderBy =&order=; line: 149, file: /var/www/html/espocrm/application/Espo/Services/GlobalSearch.php

Global search returning error. What should I do?

All my tables using the same collation, as you can see below.



Thanks

[rodrigocoelho]

Solved. the columns where not on the same collation.

[esforim]

Solved. the columns where not on the same collation.

Are you able to elaborate in case I run into this issue in the future. Not sure how you solve the issue at this stage.

[rodrigocoelho]

I used a program to browse the database (HEIDISQL), and saw that, even the tables showing the same collation, the columns inside some tables were using a different one. So, using the HEIDISQL, I changed that columns collation as well