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

CSS Column Layout

When working on websites, one of the most common patterns is column-layout. You want have some main content flow in the center of the page, and have one or two...

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...

Econ 101 – International Trade

You wish to secure the national market to national labor. We are subjected to the intolerable competition of a foreign rival... Which country cannot... leave us now to struggle unprotected...