--- a/exportData.csv.php +++ b/exportData.csv.php @@ -1,7 +1,7 @@ <?php include_once("./lib/common.inc.php"); - +setlocale(LC_CTYPE, 'C'); // source: http://stackoverflow.com/questions/81934/easy-way-to-export-a-sql-table-without-access-to-the-server-or-phpmyadmin#81951 $result = mysql_query(' SELECT CNID,contractnotice.agencyName,agency.abn as agencyABN,publishDate,contractStart,contractEnd,value,description,procurementMethod,category,categoryUNSPSC @@ -22,6 +22,10 @@ header('Expires: 0'); fputcsv($fp, $headers); while ($row = mysql_fetch_assoc($result)) { + foreach ($row as &$colvalue) { + $colvalue = preg_replace( '/[^[:print:]]/', '', + utf8_encode($colvalue)); + } fputcsv($fp, array_values($row)); } die;