reading DB info (special chars)

[Applellial]

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

[monkeytooth]

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.