How can I modify database charset?

You can modify database charset using phpmyadmin at any time. Simply select the database you want to edit, click 'Operations' tab and look for 'Collation' field.

Select new charset and click 'Go' button to save your changes. If you need to modify charset for an individual table or even field, you can repeat the same operation after selecting desired table or field :)