ok i have a site with iso-8859-1 i wanted to change it to utf-8 after a week of googling reading and testing i managed to insert properly the characters at mysql db from my php script.but when i call the script it doesnt show correctly the characters does anybody knows something about that?
yes i pass the headers properly i also setnames utf8 after connection mysql system variables are all utf8 also the charset is proper on my database but when i call it then it is not.i think that php does not set the proper charset when retrieves data from my db.but it behaves good when inserts data. oh maybe because my db data iso-8859-1 except from the last that i insert and this is causing the problem? but then why phpmyadmin doesnt have problem with this? the thing is that these problems has a solution like phpmyadmin never shows wrong charset even if your server isn't set up proper.i say this because some people say that there is no solution to this.my opinion is that everything can be solved thats why we like computers
These links might help you: http://www.howtoforge.com/forums/showthread.php?t=2557 http://www.howtoforge.com/forums/showthread.php?t=3390 http://www.howtoforge.com/forums/showthread.php?t=3649
