mysql and phpmyadmin and char issue

Below is the trick that fixes the charter issue when importing data via phpmyadmin.

SET NAMES 'utf8';