Error Error:1267-Illegal mix of collations

I have a MySQL View that feeds a grid. The grid works fine, but when I search I get this:
Error:1267-Illegal mix of collations (utf8_bin,NONE) and (utf8_general_ci,COERCIBLE)

I understand that this is something to do with the collations used on the view, but I'm struggling with this!

Can anyone help?

Still struggling - I can't seem to use the Collation or Charset keywords on a view - they seem only to apply to tables.

I'm reluctant to change the default charset/collation.

I have to do some other things for a couple of days, but thanks for the idea - I will have a look later this week.

Sorted this out. Collations seem to be an issue on views, but I solved the problem by the following:

CONVERT(format(table.fieldname,0) using utf8) as User_id

I did this on the fields that were not collating to the default.

Once I did this, the search operated fine.

Bob