Error
Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='
SQL Query
SELECT sku as sku_code, collection_name, brand_name
FROM (SELECT catalog_product_entity.entity_id, sku, value
FROM catalog_product_entity
JOIN catalog_product_entity_int ON catalog_product_entity.entity_id = catalog_product_entity_int.entity_id
WHERE attribute_id = 187) AS subquery
JOIN collection_info ON option_id = subquery.value
Where brand_name='X' and collection_name='Y'
Post "Diagnostic Info" from Admin > Troubleshooting.
In your setup of Metabase, you have set the Metabase application database (where Metabase stores all it's information) to MySQL.
That database needs to be charset utf8mb4 and collation utf8mb4_unicode_ci - including for every table and column within.
@Anum I can only see that you're running on AWS, but not if you're using JAR or Docker, but change collation on the application database for the database and all tables and all columns.
@Anum I'm just going to stop writing, since you are not reading what I'm writing.
You are misunderstanding the difference between data source queries and the application database.