I've been struggling to find a solution this problem, I have found the following php script:
Expand|Select|Wrap|Line Numbers
- <?php
- $db = mysql_connect('localhost','myuser_mydbuser','mypassword');
- if(!$db) echo "Cannot connect to the database - incorrect details";
- mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
- while($tables = mysql_fetch_array($result)) {
- foreach ($tables as $key => $value) {
- mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");
- }}
- echo "The collation of your database has been successfully changed!";
- ?>
Is there a fast way to do this?
The reason why i 'think' i need to do this is so that i can server up pages AND RSS feeds encoded in the utf-8 format, as I am having trouble with wierd characters in my feed.
Thanks,
Chromis