tivrfoa

hmmm it should be: Jos? In edited: it's not displaying correctly here too trying ... & eacute & circ José Inês

Hi, I changed everything to utf8_bin: MySQL connection collation, database, table and column. http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html And then I run in phpMyAdmin: set names 'utf8'; update clientes set nome = 'Jos? In?s'; And the problem remains. Only display correctly at phpMyAdmin. I also tested header('Content-type: text/html; charset=utf-8'); but didn't work. http://www.w3.org/International/O-HTTP-charset.en.php For display these data correctly I would need to use utf8_encode everywhere (ouch!!!). It's interesting the number of comments that the page about utf8_encode has: http://php.net/manual/en/function.utf8-encode.php I'll read more, but meanwhile I'll fill the tables using PHP script and not phpMyAdmin. Regards, Leandro.

Hi, The problem occurs when the data is inserted using phpMyAdmin. This function is not necessary in my script. And this function is not recommended to change the charset. -> http://php.net/manual/en/function.mysql-set-charset.php Thank you.

Hi, So ... when I insert the data through the phpMyAdmin page, it displays correctly in phpMyAdmin but not on the page (where matters). I created a web form to fill the table from there, and then the data displays incorrectly in phpMyAdmin, but correctly in the page! Well. Problem solved I guess. One thing that I'll test is if the collate and character set matters (I changed from utf8 to latin1), or the problem was because I inserted directly using phpMyAdmin. Regards, Leandro.

Hi, I'm using PHP and MySQL. It's working fine at my PC (localhost), but it's not on my web hosting. Cordão -> should be Cord?o It's displaying Cord?o at phpMyAdmin. So I checked the collate and character set to see if it's different. They were, so I changed: alter DATABASE db_name CHARACTER SET latin1 COLLATE latin1_swedish_ci; alter table table_name CHARACTER SET latin1 COLLATE latin1_swedish_ci; But this didn't resolved the problem. :'( What else might be the problem? I don't think it's <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> because it's all working fine at my notebook. Regards, Leandro.

Hi, The links for PHP Help, MySQL Help, ... at the home page are broken. (right side menu) eg: Should be: http://forums.phpfreaks.com/index.php?board=3.0 Instead of: http://www.phpfreaks.com/forums/index.php/board,3.0.html Regards, Leandro.