I have a mysql database and use a php application that captures, stores, retrieves and displays data correctly - including French language words with accents. It has been running for around five years. I've recently written an extension that creates an openoffice writer document using this data. Everything works apart from the these wretched French characters!!! If I unzip the odt package and examine content.xml, then the characters are wrong - but simply cutting and pasting correct ones in gives me a working document, so the error is definitely in the way I am creating the content using php.
An example of the problem is Côte. As I've just typed it, the o has a circumflex accent or 'hat' on it. Within the odt file, the o-circumflex is shown as ô. Piping this to od -c gives 303 203 302 264. If I take the o-circumflex character from gnome charmap and od -c this, then I get 303 264. If I copy the character from my php/web app then it is correct. Where are these two middle bytes coming from? I've tried various combinations of mbstring functions and ini file settings but without joy. Thanks for any help you can give me. -- PHP Unicode & I18N Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php