Problem with mbstring data
Posted: Sat Jun 27, 2009 11:45 pm
I have a mysql database and 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 okay 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. 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.
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. 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.