Publications

MySQL error 1253

COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'

MySQL error 1253

COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'

phpMyEdit error: invalid SQL query


SELECT `PMEtable0`.`year` AS `qf0`,`PMEtable0`.`authors` AS `qf1`,CONCAT(if(link !="", CONCAT("<a href=",link,">",title,"</a>"),title),if(journal!="",CONCAT(" <i>",journal,"</i>"),""),if(volume,CONCAT(", ",volume),""), if(number,CONCAT("(",number,")"),""),if(pages,CONCAT(", pp",pages),""), if(doi!="",CONCAT(". DOI: <a href=http://dx.doi.org/",doi,">",doi,"</a>"),""),if(journal!="",CONCAT(" [<a href=bibtex.php?id=",id,">bibtex</a>]"),"")) AS `qf2` FROM `pubs` AS `PMEtable0` WHERE (CONCAT(if(link !="", CONCAT("<a href=",link,">",title,"</a>"),title),if(journal!="",CONCAT(" <i>",journal,"</i>"),""),if(volume,CONCAT(", ",volume),""), if(number,CONCAT("(",number,")"),""),if(pages,CONCAT(", pp",pages),""), if(doi!="",CONCAT(". DOI: <a href=http://dx.doi.org/",doi,">",doi,"</a>"),""),if(journal!="",CONCAT(" [<a href=bibtex.php?id=",id,">bibtex</a>]"),"")) LIKE '%Web Browser Privacy%' COLLATE latin1_general_ci) ORDER BY `PMEtable0`.`year` DESC LIMIT 0, 50Page 1 
Year Authors Title