SELECT DISTINCT id, label, address, country, CONCAT_WS('', TRIM(SUBSTRING(publishers.comment_fr, 1, 200)), IF(LENGTH(publishers.comment_fr) > 200, '...', '')) AS comment FROM publishers LEFT JOIN rel_works_publishers ON rel_works_publishers.publisher = publishers.id WHERE label REGEXP '^[uUܵ]' AND work IS NOT NULL ORDER BY label [nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp']