How to recreate issue: Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)

Can anyone suggest how to recreate issue Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)

This was triggered due API /admin/products and "action"=>"index".

Error:

/admin/products#GET params: { "controller"=>"admin/products"}, 
exception: ActiveRecord::StatementInvalid, message: Mysql2::Error:
 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and 
(utf8_general_ci,COERCIBLE) for operation 'like'