morocco-iceberg Posted May 25, 2010 Share Posted May 25, 2010 I've used php and mysql to populate this exam, and used " double quotations so that apostrophes won't cause trouble, however, as you can see in the image, random apostrophes come through as question marks with black diamonds while others on the page work normally... ANyone know why and how I can fix this? Quote Link to comment https://forums.phpfreaks.com/topic/202803-question-marks-in-black-diamonds-instead-of-apostrophes/ Share on other sites More sharing options...
premiso Posted May 25, 2010 Share Posted May 25, 2010 Change your database encoding and the webpage charset to be UTF-8 and that should solve it. Quote Link to comment https://forums.phpfreaks.com/topic/202803-question-marks-in-black-diamonds-instead-of-apostrophes/#findComment-1062871 Share on other sites More sharing options...
morocco-iceberg Posted May 25, 2010 Author Share Posted May 25, 2010 I changed the database character set/encoding thing to utf8-bin (there was no option for just utf8), but it hasn't solved anything :/ and now in the database it shows these: [bLOB - 46B] instead of the data. Quote Link to comment https://forums.phpfreaks.com/topic/202803-question-marks-in-black-diamonds-instead-of-apostrophes/#findComment-1062888 Share on other sites More sharing options...
premiso Posted May 25, 2010 Share Posted May 25, 2010 The utf8-bin = binary. So yea. You need the regular UTF8 or utf8_general_ci Quote Link to comment https://forums.phpfreaks.com/topic/202803-question-marks-in-black-diamonds-instead-of-apostrophes/#findComment-1063060 Share on other sites More sharing options...
morocco-iceberg Posted May 26, 2010 Author Share Posted May 26, 2010 Hmm, I changed it to the utf8_general_ci but it still didn't work... Thanks for the help though Quote Link to comment https://forums.phpfreaks.com/topic/202803-question-marks-in-black-diamonds-instead-of-apostrophes/#findComment-1063516 Share on other sites More sharing options...
premiso Posted May 26, 2010 Share Posted May 26, 2010 Well if the data was entered in the latin mode from a page that was non-UTF8 charset encoded, yea. Try making a new post with the same characters and make sure the charset of the page that submits the data is UTF-8 and see if it works or not. Quote Link to comment https://forums.phpfreaks.com/topic/202803-question-marks-in-black-diamonds-instead-of-apostrophes/#findComment-1063614 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.