Applellial Posted April 6, 2011 Share Posted April 6, 2011 hi, I'm making a website, in portuguese, and i'm trying to retrieve characters with accent signals such as é ê á etc. while when I directly type words with such characters directly in my HTML, it displays correctly (i'm using utf-, if i save the same words into a mysql DB, and echo them out with php, they will appear with missing characters, you know, the "?" inside a square. im clueless. any help is appreciated. thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/232836-reading-db-info-special-chars/ Share on other sites More sharing options...
monkeytooth Posted April 6, 2011 Share Posted April 6, 2011 Chances are you have to 1 change the "Collation" type of the table/column your storing the data in within the DB, most DB's by defualt (that ive run into) seem to set it to some latin charset by default. Which when stored might be losing the character in translation so to speak. 2 you might need to use something like http://php.net/manual/en/function.utf8-decode.php when calling the data out. Quote Link to comment https://forums.phpfreaks.com/topic/232836-reading-db-info-special-chars/#findComment-1197655 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.