Page 1 of 1

Character Entity Problem

Posted: Tue Apr 25, 2006 11:45 pm
by Benjamin
Anyone know why

&#146 ;

gets converted to

’

After being saved into a database?

The only PHP function being performed on it is mysql_real_escape_string();

I put a space in there so it wouldn't render it as a ’

Posted: Wed Apr 26, 2006 4:50 am
by timvw
Do you mean that your browser renders the entity? (as in expected behaviour)

Posted: Wed Apr 26, 2006 10:52 am
by Benjamin
No ’ is getting spit out in the source when you view the page.

Posted: Wed Apr 26, 2006 11:30 am
by Chris Corbyn
agtlewis wrote:No ’ is getting spit out in the source when you view the page.
What does it look like on the command line using the mySQL client (and perhaps in phpMyAdmin) ?

Posted: Wed Apr 26, 2006 1:33 pm
by Benjamin
It's in the database as ’. It must be a php configuration issue. On my local server it works fine, it's only doing this on the live server.