How to change the collation for all tables in a MySQL database to UTF-8?AA-00328Changing the collation for all tables in a MySQL database can be time consuming depending on how many tables you have. That’s why we recommend using the following PHP script for changing the collation for all tables at a time: <?php Make sure to substitute in the above script: - myuser_mydbname with your database name; - myuser_mydbuser with your mysql username; - mypassword with your password for the mysql user; - utf8-general_ci with your new collation if different; |