I've recently just swapped all of a databases tables and columns to
utf8_unicode_ci from the weird collection of about 3-5 different collations they were previously (don't ask... not my database)
So, every table, every column, and the database itself is set to utf8_unicode_ci.
Doing stuff inside of phpmyadmin, everything works fine.
However, switch to mysql workbench, and this is where things get fun. Running a simple select query
select * from table where field like value or field2 like value
results in the following:
Error Code: 1267. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'like'
Now, I'm a bit stumped, from everything I've read, most people get this error if they have columns or tables which are different collations... I've double and triple checked that they are all utf8 unicode.
Someone else mentioned an issue with workbench, but they didn't go into detail of how they fixed it...
Anyone have any ideas?