fix_mixed_encoding.php

<?php

// show usage
if(!is_file($argv[1]) || empty($argv[0])) {
	echo "\nUsage: > php fix_mixed_encoding.php inputfile.sql outputfile.sql\n";
	exit;
}

// replace damaged utf8 characters with fixed ones
function fixMixedCharacters($string) {
	$searchReplace = array(
	'ü'=>'ü',
	'ä'=>'ä',
	'ö'=>'ö',
	'Ö'=>'Ö',
	'ß'=>'ß',
	'Ã '=>'à',
	'á'=>'á',
	'â'=>'â',
	'ã'=>'ã',
	'ù'=>'ù',
	'ú'=>'ú',
	'û'=>'û',
	'Ù'=>'Ù',
	'Ú'=>'Ú',
	'Û'=>'Û',
	'Ãœ'=>'Ü',
	'ò'=>'ò',
	'ó'=>'ó',
	'ô'=>'ô',
	'è'=>'è',
	'é'=>'é',
	'ê'=>'ê',
	'ë'=>'ë',
	'À'=>'À',
	'Á'=>'Á',
	'Â'=>'Â',
	'Ã'=>'Ã',
	'Ä'=>'Ä',
	'Ã…'=>'Å',
	'Ç'=>'Ç',
	'È'=>'È',
	'É'=>'É',
	'Ê'=>'',
	'Ë'=>'Ë',
	'ÃŒ'=>'Ì',
	'Í'=>'Í',
	'ÃŽ'=>'Î',
	'Ï'=>'Ï',
	'Ñ'=>'Ñ',
	'Ã’'=>'Ò',
	'Ó'=>'Ó',
	'Ô'=>'Ô',
	'Õ'=>'Õ',
	'Ø'=>'Ø',
	'Ã¥'=>'å',
	'æ'=>'æ',
	'ç'=>'ç',
	'ì'=>'ì',
	'í'=>'í',
	'î'=>'î',
	'ï'=>'ï',
	'ð'=>'ð',
	'ñ'=>'ñ',
	'õ'=>'õ',
	'ø'=>'ø',
	'ý'=>'ý',
	'ÿ'=>'ÿ',
	'€'=>'€'
	);
	return str_replace(array_keys($searchReplace), $searchReplace, $string);
}

// open input file
$fp = fopen($argv[1], 'r');
// open/create output file
$fp2 = fopen($argv[2], 'w+');
// read the whole file by 4098 byte pieces and fix the encoding
while(!feof($fp)) {
	$fixThisString = fread($fp, 4098);
	$fixThisString = fixMixedCharacters($fixThisString);
	fwrite($fp2, $fixThisString);
}
fclose($fp);
fclose($fp2);