Gaby T. wrote:

I am running into a problem where as I want to store test form a text field
to a database (MySql in this case, sql type "text").
Apparently, if people are cutting and
pasting text from another document (typically MS WORD) into the textfield,
the text gets only partially saved. I am assuming wierd characters are being
introduced in this manner (I definitively know this is a problem with rounded quotes) and although I am using the basic "addslashes" function, it's not enough.
Has anyone seen this before and is there a fix?

I believe Tom Rodgers from the PHP general list provided this answer when I posted a similar question about a year ago...

$submitted_text = $_POST['textFromTextArea'];

function clean_ms_word($writing)
$crap = array(chr(0x82),chr(0x83),chr(0x84),chr(0x85),chr(0x86),chr(0x87),chr(0x88),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;','†','‡','','‰','Š','‹','Œ','‘','’','"','"','•','–','—','˜','™','š','›','œ','Ÿ');
$content = str_replace($crap,$clean,$writing);
return $content;

$usable = clean_ms_word($submitted_text);

This has worked wonderfully for my applications!


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to