keithodulaigh.com Posted July 22, 2009 Share Posted July 22, 2009 Hi Everyone, I know that there's a lot of discussion about character encoding and after searching I'm still having problems. I set up a database table for users with utf8_general_ci as the collation. I then tried inserting "Ó Dúlaigh" as the last name of a test user. When I view the database then in phpMyAdmin that name appears incorrectly like an A with a tilde on top. I've tried running the name throught htmlentities() and doing a strtr() but that just made that name appear as: Ó Dúlaigh. My PHP script is saved with UTF8 encoding. I've also tried reading back the data from the database without using phpMyAdmin but appears messed up as well. Can anyone offer me some advice on this problem? Not all of my special characters will be hard-coded into the script. Some will be the result of user input. Many thanks, Keith Quote Link to comment https://forums.phpfreaks.com/topic/167015-character-encoding-question/ Share on other sites More sharing options...
celsoendo Posted July 23, 2009 Share Posted July 23, 2009 Try utf8_encode() or utf8_decode() on php after retrieving the data from mysql. Quote Link to comment https://forums.phpfreaks.com/topic/167015-character-encoding-question/#findComment-880908 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.