Re^4: Removing Foreign Characters


Don't ask to ask, just ask
	PerlMonks

Re^4: Removing Foreign Characters

by existem (Sexton)

on Jan 27, 2005 at 18:05 UTC ( [id://425663]=note: print w/replies, xml )

Need Help??

in reply to Re^3: Removing Foreign Characters
in thread Removing Foreign Characters

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(
    "À" => "&Agrave;",
    "à" => "&agrave;",
    "Á" => "&Aacute;",
    "á" => "&aacute;",
    "Ã" => "&Atilde;",
    "Ì" => "&Igrave;",
    "ì" => "&igrave;",
    "Í" => "&Iacute;",
    "í" => "&iacute;",
    "Î" => "&Icirc;",
    "î" => "&icirc;",
    "Ò" => "&Ograve;",
    "ò" => "&ograve;",
    "Ó" => "&Oacute;",
    "ó" => "&oacute;",
    "Ô" => "&Ocirc;",
    "ô" => "&ocirc;",
    "é" => "&eacute;",
    "è" => "&egrave;",
    "È" => "&Egrave;",
    "Ù" => "&Ugrave;",
    "ù" => "&ugrave;",
    "Ú" => "&Uacute;",
    "ú" => "&uacute;",
    "Û" => "&Ucirc;",
    "û" => "&ucirc;",
    "¢" => "",
    "©" => ""
);

$name = strtr($row["name"], $trans2);
[download]

I'm off to the pub now to think about it a bit more ;)