Change Database Charset and Collation
Log into phpMyAdmin. Select your database from the left menu. Click on “Operations” from the top menu. In the Collation box, choose your new collation from the dropdown menu (utf8_general_ci is the common collation).