Strange characters...

[jamiller]

So I've built an program that takes some text and inserts that into a MySQL database with htmlentities and addslashes so it gets inserted no problem. However when it is read from the database with html_entity_decode a bunch of strange characters get displayed.

http://www.ja-miller.com/test/

Anybody have any ideas?

[Nile]

Well, form what I see all you have are `?` replacing thinks like maybe some odd weird character('¿'). Or maybe its not odd its just a simple single quote('). But I think it depends on what kinda field you have in your collation[I think thats what its called].

I hope this helps.
Nile

[jamiller]

Not completely sure what you were trying to say there... But, I changed the collation to several different types (from the default of latin1_swedish_ci) and no luck.

From looking at the source, something is happening with non breaking spaces (&nbsp. However it makes absolutely no sense to me why this would be happening...

Thanks for trying tho!

[boogyman]

use character encoding, and set it to UTF-8

[jamiller]

Thanks for the response as always boogy! But how do I "use character encoding?" I did some googling and found out how to change it in php.ini. So I un-commented out the line, changed it from the default iso-something to UTF-8, and restarted the services but that didn't change anything.

Thanks

[jamiller]

:P

Fixed it!! Explicitly telling the html_entity_decode function to expect UTF-8 worked perfectly!

Thanks again!