peter(Mittwoch, 22. Aug 2007)
Comment: Using the acars search I get an error message:SQL ERROR: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin2_general_ci,IMPLICIT) for operation '='
STATEMENT: SELECT manu,short,id,timestamp,day,month,year,mode,block,label,ACARSDATA.reg,msgno,flightnum,route,operator,message FROM ACARSDATA LEFT JOIN aircrafts ON ACARSDATA.reg = aircrafts.reg WHERE timestamp BETWEEN 1187733601 AND 1187819999 AND flightnum LIKE 'lh%' ORDER BY timestamp desc LIMIT 0,50