error in mysql collation_name

I have an error in MySQL:

  

error code: 1267 illegal mix of   collations (latin1_swedish_ci.IMPLICIT) and   (latin1_spanish_ci.implicit) for operation '='

I have made a query to show me the tables where collation_name sea = latin1_swedish_ci and returns records, but with latin1_spanish_ci I do not have any table. Does anyone know what this error can be?

SELECT 
    table_name,
    column_name
FROM
    information_schema.columns
WHERE
    collation_name = 'latin1_swedish_ci'