RE: [PHP-DB] Text corruption when storing to MySql
| From: | Norland, Martin | Date: | Wed, 20 Oct 2004 20:54:37 +0000 |
| Subject: | RE: [PHP-DB] Text corruption when storing to MySql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36943@lists.php.net to get a copy of this message | ||
$content = str_replace($crap,$clean,$submitted_text);
:)
(I hadn't even noted you missed any at first)
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-----Original Message-----
From: Roger Spears [mailto:roger@bgnet.bgsu.edu]
Sent: Wednesday, October 20, 2004 3:41 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Text corruption when storing to MySql
I missed a variable in my previous post....should have been this:
$submitted_text = $_POST['textFromForm'];
function clean_ms_word($submitted_text)
{
$crap =
array(chr(0x82),chr(0x83),chr(0x84),chr(0x85),chr(0x86),chr(0x87),chr(0x
88),chr(0x89),chr(0x8a),chr(0x8b),chr(0x8c),chr(0x91),chr(0x92),chr(0x93
),chr(0x94),chr(0x95),chr(0x96),chr(0x97),chr(0x98),chr(0x99),chr(0x9a),
chr(0x9b),chr(0x9c),chr(0x9f));
$clean =
array('‚','ƒ','„','&ldots;','†','‡','',
'‰','Š','‹','Œ','‘','’','"',
'"','•','–','—','˜','™','š','&r
saquo;','œ','Ÿ');
$content = str_replace($crap,$clean,$writing);
return $content;
}
$usable = clean_ms_word($submitted_text);
HTH,
Roger
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php