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

On War

I'm reading The Art of War, edited by John Minford. I found there an interested passage. It is a quote from Records of the Grand Historian, which was written by...

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

CSS and Seperation of Concern

There is an old wisdom in computer engineering that software should be divided into independent components. This is called a separation of concern principle. This principle should be practiced when...