I am trying to convert the database from ASCII to UTF-8, but I thought it is better to know if there is script of software can convert my database (sql file).. any experience in this database issue?
there certainly might be more than 2 solutions for this situation .. using Linux - one option to convert charset is the same as for all files - html and other files as well. the other option would be phpmyadmin this allows to import a mysql db from another charset into the configured one of the current db. there might be other solutions as well. after doing your charset conversion - open the db in an editor - read only - and check if all special characters LOOK right - then they ARE rigvht in the db as well.