Totalizar cross table

[AlZuwaga]

Hola, siguiendo la misma lógica del query anterior, coloqué esto:

Código:

SELECT 'Total',
SUM(IF(id_tema = 1, 1, 0)) AS caso1,
SUM(IF(id_tema = 2, 1, 0)) AS caso2, 
SUM(IF(id_tema = 3, 1, 0)) AS caso3, 
SUM(IF(id_tema = 4, 1, 0)) AS caso4, 
COUNT(*) AS total
FROM provincias INNER JOIN ml_ordenanzas USING (id_provinc)

Y me trae los resultados esperados para los totales. Pero... cuando hago un UNION de la consulta del post anterior y la de éste post, quedando así, ...

Código:

SELECT provincia,
SUM(IF(id_tema = 1, 1, 0)) AS caso1, 
SUM(IF(id_tema = 2, 1, 0)) AS caso2, 
SUM(IF(id_tema = 3, 1, 0)) AS caso3, 
SUM(IF(id_tema = 4, 1, 0)) AS caso4, 
COUNT(*) AS total
FROM provincias INNER JOIN ml_ordenanzas USING (id_provinc)
GROUP BY provincia

UNION
SELECT 'Total',
SUM(IF(id_tema = 1, 1, 0)) AS caso1,
SUM(IF(id_tema = 2, 1, 0)) AS caso2, 
SUM(IF(id_tema = 3, 1, 0)) AS caso3, 
SUM(IF(id_tema = 4, 1, 0)) AS caso4, 
COUNT(*) AS total
FROM provincias INNER JOIN ml_ordenanzas USING (id_provinc)

... me dice:

MySQL ha dicho:
#1267 - Ilegal mezcla de collations (latin1_swedish_ci,IMPLICIT) y (utf8_general_ci,COERCIBLE) para operaci�n 'UNION'

¿qué ocurre?