How to fix the MySQL error: Illegal mix of collations for operation union

--

Photo by Rubaitul Azad on Unsplash

Well, you probably have different collations in some MySQL views, try to force collation like this:

Obviously… force to uft8 if you want this collation.

--

--

Massimo Caliman
Massimo Caliman

Written by Massimo Caliman

Software Architect, Developer, Java enthusiast

No responses yet