I have 2 php2excel scripts laying on seperate servers and they are identical. The first export hebrew well, and the other gets question marks. Same database on both servers. So we can say for sure this is a server problem.? can we?
here are the links:
http://creditcardsafety.net/land3/PHParadise-mySQL_to_excel.php
http://www.cdi.co.il/land3/PHParadise-mySQL_to_excel.php
BTW: all other servers i tried gives question marks.
So what can it be on this particullar server that makes it works?
Thanks guys/
Make sure your databases on all servers have the right encoding.
You should also make sure that you are connecting to the database with the right encoding for your connection.
For MySQL: http://php.net/manual/en/function.mysql-set-charset.php
Something to test might be to send the right encoding as a header when you are prompting the download in your PHP script.
header('Content-Type: text/html; charset=iso-8859-1'); // change to your encoding
All connections headers server code and client html all identical on both servers. So it must be a server prblem dont it???
I found a way, Excel opens xml files, So I now export sql to xml. Is it a suitable solution?