thanks for the help guys, I think i've kind of hacked this one ;) here's what i've done.
This is actually PHP, I did it on the front end, rather than at the point of loading into the database.
$trans = array(
"À" => "À",
"à" => "à",
"Á" => "Á",
"á" => "á",
"Ã" => "Ã",
"Ì" => "Ì",
"ì" => "ì",
"Í" => "Í",
"í" => "í",
"Î" => "Î",
"î" => "î",
"Ò" => "Ò",
"ò" => "ò",
"Ó" => "Ó",
"ó" => "ó",
"Ô" => "Ô",
"ô" => "ô",
"é" => "é",
"è" => "è",
"È" => "È",
"Ù" => "Ù",
"ù" => "ù",
"Ú" => "Ú",
"ú" => "ú",
"Û" => "Û",
"û" => "û",
"¢" => "",
"©" => ""
);
$name = strtr($row["name"], $trans2);
I'm off to the pub now to think about it a bit more ;)
|