epicasian Posted January 30, 2010 Share Posted January 30, 2010 Hello, I am trying to have all my body text for a news website I am building, inside a MySQL DB, and when I echo it out in PHP, it shows symbols like � instead of ". Can anyone help me? Thank you, EpicAsian P.S. I've tried the ASCII, ARMSCII8, and utf8_Unicode Link to comment https://forums.phpfreaks.com/topic/190374-database-collation-question/ Share on other sites More sharing options...
dpacmittal Posted January 30, 2010 Share Posted January 30, 2010 Try: latin1_swedish_ci Link to comment https://forums.phpfreaks.com/topic/190374-database-collation-question/#findComment-1004312 Share on other sites More sharing options...
epicasian Posted January 30, 2010 Author Share Posted January 30, 2010 i just tried that, and it's still echoing out the � Thanks, EpicAsian Link to comment https://forums.phpfreaks.com/topic/190374-database-collation-question/#findComment-1004316 Share on other sites More sharing options...
dpacmittal Posted January 30, 2010 Share Posted January 30, 2010 Is it displaying correctly in PHPmyadmin? Link to comment https://forums.phpfreaks.com/topic/190374-database-collation-question/#findComment-1004333 Share on other sites More sharing options...
epicasian Posted January 30, 2010 Author Share Posted January 30, 2010 yes, it is EDIT: I fixed it, i guess all i needed to do was change the type to utf8_unicode_ci and in the HTML, put utf8_unicode_ci in the META tag Thank you everyone for helping me! ~EpicAsian Link to comment https://forums.phpfreaks.com/topic/190374-database-collation-question/#findComment-1004336 Share on other sites More sharing options...
dpacmittal Posted January 30, 2010 Share Posted January 30, 2010 put utf8_unicode_ci in the META tag That is why I asked if phpmyadmin was showing it right. Link to comment https://forums.phpfreaks.com/topic/190374-database-collation-question/#findComment-1004340 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.