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

Prima Mano Primitivo

Bold Style This wine is made of the Primitivo grape - the Italian version of Zinfandel. It represents the best selection of Primitivo grapes in Italy. Full-bodied and chewy in...

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

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