sincityalex Posted November 6, 2009 Share Posted November 6, 2009 Hey all, I have a PHP admin where i can copy and paste text to update the front end of the site. But for some reason when it gets dumped into the database it shows up with question marks in diamonds on the front end. I know its a formatting issue, but any ideas on how to resolve this? Example would be at: http://www.bradhagermlm.com/memoRead.php?memo_id=4 Any help would be great. Link to comment https://forums.phpfreaks.com/topic/180604-diamonds-with-question-marks-showing-up/ Share on other sites More sharing options...
cags Posted November 6, 2009 Share Posted November 6, 2009 It's because a particular type of character is used and the charset of either your output or your database connection are not set up to support it. Looking at your HTML it appears you have set UTF-8 using the meta tag for ContentType which means it's probably the database connection. Just after connecting to the database you can set the character set for the connection. Off the top of my head I think it's something like... mysql_query("SET CHARACTER SET utf8"); mysql_query("SET NAMES utf8"); Link to comment https://forums.phpfreaks.com/topic/180604-diamonds-with-question-marks-showing-up/#findComment-952858 Share on other sites More sharing options...
sincityalex Posted November 6, 2009 Author Share Posted November 6, 2009 Thanks cags, ill give it a try and let you know how it pans out Link to comment https://forums.phpfreaks.com/topic/180604-diamonds-with-question-marks-showing-up/#findComment-952861 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.