MySql->PHP->Excel=french weird chars
| From: | Marios Adamantopoulos | Date: | Wed, 27 Nov 2002 17:19:03 +0000 |
| Subject: | MySql->PHP->Excel=french weird chars | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-126310@lists.php.net to get a copy of this message | ||
Hi all
I'm using a MySql database to save French data. In addition, I have a PHP
page which is using
header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: attachment; filename=filename.xls");
to save all the data from the database to the excel file.
The problem is that when I open the excel file I get this: é instead of
this: é and the same thing for all the French accented chars.
I've tried to save the data as acsv file too but I get the same problem.
Does anyone have a solution?
Many Thanks
Mario
_________________________
Marios Adamantopoulos
Senior Developer
Tonic
+44 (0)20 7691 2227
+44 (0)7904 221663
www.tonic.co.uk
Recent projects
www.polydor.co.uk
www.adcecreative.org
www.sony-europe.com/pocketlife
.............................................................................
....................................
Opinions, conclusions and other information in this message that do not
relate to the official business of Tonic Design Limited shall be
understood as neither given nor endorsed by them.
.............................................................................
....................................