cannot create xlsx file if accented characters

Topics: Developer Forum, User Forum
Aug 20, 2007 at 7:31 PM
i was changing my pgm to use Excel2007_Writer and was reading user info from a MySQL DB
it choked (said spreadsheet had errors) - i tracked it down to a user that has french accented characters in some of the text fields
this was the 1st user with accented characters
do i have to do something special to handle accented characters?

Aug 21, 2007 at 6:19 AM
Please see (in short: use iconv())
Aug 21, 2007 at 5:40 PM
i am not sure what code page to use??
why doesn't the default accept french characters?

Aug 21, 2007 at 7:42 PM
UTF8 should do the trick...

Also, utf8_encode() is an option to use.