Hi,
I'm reading in xml data into my database which is encoded using utf-8. When this is displayed on my pages some characters are not displayed how I would like - eg £ is displayed as £. I know that one solution is to change my pages to utf-8 encoding - however, this means that a lot of other characters are then displayed as question marks. I could do a global search and replace on the relevant columns in the database to display these characters correctly.
However, if I do this, when anyone else adds a link or review to my database and uses any of the relevant characters, any text files - such as emails - will display them strangely. I would like to know whether anyone has any suggestions for the best way to handle this? Is there an easy way to make the conversion from utf-8 encoding when I insert the xml entries into the database?
Thanks, Laura.
I'm reading in xml data into my database which is encoded using utf-8. When this is displayed on my pages some characters are not displayed how I would like - eg £ is displayed as £. I know that one solution is to change my pages to utf-8 encoding - however, this means that a lot of other characters are then displayed as question marks. I could do a global search and replace on the relevant columns in the database to display these characters correctly.
However, if I do this, when anyone else adds a link or review to my database and uses any of the relevant characters, any text files - such as emails - will display them strangely. I would like to know whether anyone has any suggestions for the best way to handle this? Is there an easy way to make the conversion from utf-8 encoding when I insert the xml entries into the database?
Thanks, Laura.