First, run the following script. Second, execute provided commands.

mysql --database=db_name -u db_username -p -B -N -e "SHOW TABLES"  | awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}'  

 

Related Articles

Computer Backup

Mozy is a must-have product for every PC and Mac owner. It is a free, fully-automated, online backup service. Mozy cames as a small program that runs quietly on a...

Code Quality in CSS

One monumental principle of computer engineering is that software should be maintenance. It means that it shouldn't be hard to read, write, and edit existing software. This is easier to say than...

Hide Button Text

There is a simple, but genius, method to replace button with icon. I learned it from jQuery. First, create the button, as you would always do. You can use <button>...