issue with accents and mysql
| From: | mario | Date: | Tue, 15 Feb 2005 22:04:30 +0000 |
| Subject: | issue with accents and mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208780@lists.php.net to get a copy of this message | ||
Hello,
please help me on the following issue.
please reply to chiari.hm@flashnet.it too.
(I asked for help on the php-db ml, but nobody replied)
I have hacked the following function:
function accents($text) {
global $export;
$search = array ( 'à', 'è', 'ì', 'ò' ,
'ù');
$replace = array ( '\\
{a}', '\\{e}', '\\{i}',
'\\{o}', '\\`{u}');
$export = str_replace($search, $replace, $text);
return $export;
}
It works fine, as long as I feed it with a string:
accents('à') --> \`{a}
The issue is when I get 'à' from a mysql table.
I.e., for some record of a mysql table Table, let à the value of the
field Field, and say
$result = mysql_fetch_array($answer, MYSQL_BOTH),
where $answer= mysql_query(SELECT * FROM Table).
Now accents($result['Field']) returns à (instead of \`{a}).
Why? I have no idea.
Any hint is welcome.
Thanks a lot
mario