php-i18n Digest 30 Jun 2009 03:45:25 -0000 Issue 424
Topics (messages 1322 through 1322):
Problem using international characters
1322 by: Nicholas Robinson
Administrivia:
To subscribe to the digest, e-mail:
[email protected]
To unsubscribe from the digest, e-mail:
[email protected]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
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.
--- End Message ---
