撇号无法使用redactor wysiwyg进行保存

Question

When a post is edited, the text will save and be cut off at the apostrophe, the character for apostrophe does not appear too. The weird thing is if you go to add event page, the info will not be saved in database if the text includes apostrophe. I tried set charset utf8 but that had no effect (This method get from forum).

Can anyone suggest a solution for allowing the character for apostrophe? Following is part of my code, I will provide any info if you need.

<textarea class="text-input textarea wysiwyg_mini" name="description" style="height:220px"><?php echo $page['description']; ?></textarea>

Any guidance would be appreciated.

Answer 1

Solved this by using mysql_real_escape_string to escape special characters in a string for use in an SQL statement. The example code is shown below

$description=sanitize_html(mysql_real_escape_string($_POST['description']));