next »

[leaferz]

I manually entered in a sentence in mysql using phpmyadmin but once I attempt to output it the browser replaces it with a blue boxed question mark. I tried using htmlspecialchars, htmlentities, html_entity_decode with ENT_QUOTES but still nothing.

Has anyone else ever seen anything like this?

[nutballs]

thats a character encoding issue.

You are ending up with "smart quotes" which are the kind that point in the right direction instead of just the straight quotes that you actually need.

If you are pasting the text from something like Word, thats what's causing it. Paste into notepad first, then into mysql. Thats the quick and dirty fix.

Otherwise, make sure your server is sending the right character encoding type. (utf8, ansi-blah, whatever).

[leaferz]

thats a character encoding issue.

You are ending up with "smart quotes" which are the kind that point in the right direction instead of just the straight quotes that you actually need.

If you are pasting the text from something like Word, thats what's causing it. Paste into notepad first, then into mysql. Thats the quick and dirty fix.

Otherwise, make sure your server is sending the right character encoding type. (utf8, ansi-blah, whatever).

Perfect, I'll look into all of them to see which one fits.

EDIT: Just rewrote the sentence in the DB manually and now it displays properly. This was one of the few I did copy and paste from a web page. 

Thx.