Display special characters from database
Posted on 2009-04-09
I have a simple php page that allows a user to update database data. The data is then displayed on a webpage (VERY simple content admin).
Occasionaly, special characters like bullets, and trademarks are used in these updates.
IDEALLY I would like to be able to just copy and paste text with these characters in the php form that updates the database, but when I do this, I get "unknown character icons" on the display page.
Using special character codes would be okay (not optimum), but the problem I am running into is when I use the codes ("•" for example), they show up fine on the display webpage the first time, but if I go back and use the php form to make a change, the character codes show up as the characters they represent in the form field and when I update the database, the "unknown character icons" are displayed on the page again, thus creating a situation where I have to convert the characters to their code counterparts everytime I edit the page.
How can I get the display page to display the special characters, or, short of that, retain the character codes when I edit the data in my php form?
Thanks in adavance.