exit44 Posted March 16, 2010 Share Posted March 16, 2010 I'm using php/mysql and the circle 'r' character (®) looks like it is supposed to in the DB.... just like a registered trademark symbol. But, when I print it out to an HTML page I get the funny looking question mark character. I have used htmlentities() and html_entity_decode() to try to fix it but it doesn't seem to be working. Does anyone know how to fix this? Quote Link to comment https://forums.phpfreaks.com/topic/195390-circle-rs-are-driving-me-crazy/ Share on other sites More sharing options...
gizmola Posted March 16, 2010 Share Posted March 16, 2010 Sounds like a mismatch between the character set of the page and the database table. Are they both UTF-8? Seems like you have one or the other that doesn't match. Quote Link to comment https://forums.phpfreaks.com/topic/195390-circle-rs-are-driving-me-crazy/#findComment-1026780 Share on other sites More sharing options...
exit44 Posted March 16, 2010 Author Share Posted March 16, 2010 I have the db set to "utf8_general_ci" and the page set to UTF-8. There are a bunch of options in the MySQL DB for UTF-8... like "utf8_general_ci", "utf8_bin", "utf8_chech_ci", etc... Not sure which to choose. Quote Link to comment https://forums.phpfreaks.com/topic/195390-circle-rs-are-driving-me-crazy/#findComment-1026783 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.