Resultados da busca

mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed, match (ititle,ibody,imore) against (' carl sagan ') as score FROM nucleus_item as i, nucleus_member as m, nucleus_category as c WHERE i.iauthor=m.mnumber and i.icat=c.catid and i.idraft=0 and i.iblog in (1) and i.itime<="2024-11-24 05:27:51" and match (ititle,ibody,imore) against ('carl') > 0 AND match (ititle,ibody,imore) against ('sagan') > 0 ORDER BY score DESC LIMIT 0,10: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (latin1_general_ci,IMPLICIT), (latin1_general_ci,IMPLICIT) for operation 'match'