Error in Selection Query <br> SELECT a.id,a.ad_title,a.ad_image,a.ad_description,b.id as cate_id,b.cate_name,c.id AS subcateId,c.sub_name,d.name AS ctyName,DATE_FORMAT(a.created_on,'%a., %b %D, %Y') AS createdon 
	FROM tbl_postads as a 
	LEFT JOIN tbl_category as b ON b.id=a.cate_id AND b.status='Active'
	LEFT JOIN tbl_subcategory as c ON c.id=a.sub_id AND c.status='Active'
	LEFT JOIN tbl_state AS s ON s.id = a.state_id AND s.status =  'Active'
	LEFT JOIN tbl_city as d ON d.id=a.city_id AND d.status='Active'
	LEFT JOIN tbl_readsdetail as re ON re.pa_id =a.id
	
	WHERE a.status='A'  AND ((a.ad_title like '%t����mbaram%'  OR  a.ad_description like '%t����mbaram%') OR (c.sub_name like '%t����mbaram%' OR b.cate_name like '%t����mbaram%') OR d.name like '%t����mbaram%') order by a.created_on desc<br>Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'