weird characters appear in MySQL dbase
<?php
$SQLfetch = "SELECT * FROM tblPage1";
$result_fetch = mysql_query($SQLfetch) or die ("<p>Error</p>");
$row = mysql_fetch_array($result_fetch);
if(mysql_num_rows($result_fetch)) {
$text = $row["page_text"];
$text = preg_replace("/\r\n|\n\r|\n|\r/", "<br>\n", $text);
?>
<?php
$oFCKeditor = new FCKeditor ;
$oFCKeditor->BasePath = $editorPath;
$oFCKeditor->ToolbarSet = 'Basic';
$oFCKeditor->Value = $text;
$oFCKeditor->CreateFCKeditor( 'Editor1', '100%',500 ) ;
?>
<?php
$textNew = $_POST['Editor1'];
$textNew = str_replace("'","'",stripslashes($textNew));
$SQLupdate = "UPDATE tblPage1 SET text = '".$textNew."' WHERE PageId = 1 ";
$result_update = mysql_query($SQLupdate);
?>
