I am creating XML files from my database. I understand that some sort of
character encoding is necessary in order for upper ASCII characters to be
interpreted correctly. But I am having a bit of trouble figuring out exactly
how to encode them ...
My XML file header looks like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
Here's a bit of sample problem text:
"Now available with SuperDrive, the eMac, Apple¹s most affordable PowerPC "
(note that the ¹ is a typesetting apostrophe, not a single quote mark).
When an XML file containing this text is imported into an InDesign document,
the ¹ appears as a square box.
I have tried converting the text to ISO codes, which renders this:
"Now available with SuperDrive, the eMac, Appleís most affordable PowerPC"
... which doesn't seem to be correct and still doesn't import correctly.
I tried converting the problem characters to hexadecimal, which renders
"Now available with SuperDrive, the eMac, Apple<0x2019>s most affordable"
... which still doesn't convert correctly when imported into InDesign (or
anything else for that matter)
Can anybody point me in the right direction with this?