accented letters are not showing up correctly in mysql

e.g. á, õ

[yellow_nemo]

is there an automatic ascii conversion I can do in mysql? I know I can use the replace statment to replace the character, but I would then have to find and replace all possible accented letters.

[Mr Bo Jangles]

Is it an issue with how you are telling your browser to render the pages, and if incorrectly, then saving them incorrectly - maybe?

<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">

[yellow_nemo]

well, I looked into the data in the mysql database, and those accented letters are not showing up correctly there already so I don't think it has anything to do with the browser, right?

[vincevincevince]

You'll need the text entry form to be using UTF-8 as well as the output display. If it's using another encoding - then match your page encoding to whatever is in the database.

It's also possible to set some databases to certain character sets, I normally use postgresql in unicode/utf-8