View Full Version : Export Mysql to ecxel/csv arabic encoding

01-09-2012, 08:00 AM
Hello, I want to export a mysql table to excel files and if not to csv, the problem with excel is it gives me data on one line, so I transformed it to csv and it works, the problem is it does not read arabic data

header( 'Content-Type: text/csv; charset=utf-8; encoding=UTF-8' );
header("Cache-Control: cache, must-revalidate");
header("Pragma: public");
header( 'Content-Disposition: attachment;filename=export.csv' );

Help appreciated

01-09-2012, 05:29 PM
Not sure of your browser support. Try this: header('Content-Disposition: attachment; filename*="UTF-8\'\'export.csv"');