html encoding and &quote; showing up in webpages instead of '

[pedalpete]

Strange activity here,

I was having some challenges with character encoding, and decided to just put html encoded characters in my DB, thinking they would be displayed properly when retrieved from the db.

But now I have

 " 

appearing in my pages where it should be human readable text.

you can see what I mean by going to http://www.hearwhere.com and search for a city like Paris. The second result down ('le comte de') shows

"

in the address.
If I html_entity_decode that line, i end up with a bunch of crazy black diamonds around question marks.
And i even have one of those on the page further down at "Travis Barki' and then [code] ' [ /code] below that, and

 Ã©

below that.

I have no idea why I'm getting these kinds of values.
My encoding is set to UTF-8 which seems to be right for 90% of the results. but these others are really annoying.

Anybody know how I can resolve this?
Looking in my database, it appears the data was entered as "

is there a nice way of fixing something like this?

[dlite922]

Strange activity here,

I was having some challenges with character encoding, and decided to just put html encoded characters in my DB, thinking they would be displayed properly when retrieved from the db.

But now I have

 " 

appearing in my pages where it should be human readable text.

you can see what I mean by going to http://www.hearwhere.com and search for a city like Paris. The second result down ('le comte de') shows

"

in the address.
If I html_entity_decode that line, i end up with a bunch of crazy black diamonds around question marks.
And i even have one of those on the page further down at "Travis Barki' and then [code] ' [ /code] below that, and

 Ã©

below that.

I have no idea why I'm getting these kinds of values.
My encoding is set to UTF-8 which seems to be right for 90% of the results. but these others are really annoying.

Anybody know how I can resolve this?
Looking in my database, it appears the data was entered as "

is there a nice way of fixing something like this?

or you chould just run mysql_real_escape_string() on your HTML and it will safely be entered into the database, no &quote; required.

is that an option for you? if not, why not?

Dan

[pedalpete]

I tried that before, and i wasn't working.

I had a thread here regarding that. now it seems my database is adding htmlencoded ' as &quot. even though i specify.

htmlentities($eventLoc, ENT_NOQUOTES, 'UTF-8');
 

or is that the source of the problem? should I be using something else?