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 ;)
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.