Convert character encoding in PHP
Usually while we extract information from other websites, character encoding might not correct. For example, j-jis.com is encoded with Shift-JIS. Therefore if your MySQL charset is UTF-8, it causes incorrect information. To handle the changing of character encoding, we can use
iconv in PHP.
$url = "http://j-jis.com/";
$html = file_get_contents($url);
$html = preg_replace("/rn|n|t/", "", $html); //remove unwanted characters
$html = iconv("Shift_JIS","UTF-8",$html); //convert encoding