MySQL and collations

[eluser]RS71[/eluser]
Hey

I'm having some troubles with this. I'm trying to display characters like 'ã' but MySQL is outputting as one collation and I think PHP is doing another and they keep crapping out.

I'm currently trying to work with UTF8

Could anybody possibly help me?

These are the settings that I believe I have (from phpmyadmin)

Code:

character set client         utf8
(Global value)               latin1
character set connection     utf8
(Global value)               latin1
character set database      latin1
character set filesystem     binary
character set results          utf8
(Global value)                latin1
character set server         latin1
character set system          utf8
character sets dir          C:\xampp\mysql\share\charsets\
collation connection           utf8_general_ci
(Global value)             latin1_swedish_ci
collation database          latin1_swedish_ci
collation server           latin1_swedish_ci

[eluser]RS71[/eluser]
Could somebody please assist me with this?

From what the Firefox page info and from the utf8 meta tag I set at the top of the html, I believe the page is currently set to UTF-8.

I think the MySQL is currently outputting to UTF8 but I'm not sure how to fully check this other than make sure the fields and database is set to utf8. I say I think it is because the query is currently returning 'ã' and not 'ã'.

The thing is, whenever I set the utf8 meta tag on top of the view, the words that contain 'ã' that come from the language file display some block characters with letters in them and the query will display correctly.

[eluser]libnac[/eluser]
Hi RS71,

What language would you like to show characters from?

May be UTF-8 is not valid. Try with another charset like ISO-8859-5 in your browser and change $config['charset'] = "ISO-8859-5"; on the config.php file