PHP converting Pound Signs incorrectly

[kbc1]

Hi All

I am using a WYSWYG text editor in my CMS and when I post the page to save the data, I simply capture the following field and save it to the database as such:

// UPDATE query here...
pagecontent = '".mysql_real_escape_string($pagecontent)."' 

Now for some reason this is converting £ signs to be £ in my database - why is this??

I am not converting them with htmlentities, I just want the £ signs to remain as £ signs in my database and not entity versions.

Any thoughts?

Thanks for reading.

[NogDog]

My guess is that it's the WYSIWYG editor doing the conversion, if, in fact, you are not applying htmlentities() anywhere in the data flow.