Unknown character display

**jaysmoke** · May 12, 2009, 16:43

Hi,
This is very frustrating but I have a problem. When I submit a form, the browser displays a question mark instead of the character and this is making my text display look very ugly.

Please is there anything I can do to fix this problem. The problem can be found here: http://www.thascript.com/?lid=67

**Dan Grossman** · May 12, 2009, 16:50

Your database connection or database table or both are not set to use the UTF-8 encoding you're serving the page in. The character sets you're using to store the data and to display the data must match.

**jaysmoke** · May 12, 2009, 17:01

Am so lost. Am a newbie so can you explain in plain english what I need to do to get rid of all that mess? Thanks

**JREAM** · May 13, 2009, 01:32

Hey I had this a lot as well,

in your html document it should have this meta tag to fix it (between the <head> here </head> tags)
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

**Dan Grossman** · May 13, 2009, 01:34

Originally Posted by JREAM

Hey I had this a lot as well,

in your html document it should have this meta tag to fix it (between the <head> here </head> tags)
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

He already has that meta tag, but the content in his database is not encoded as UTF-8. It looks like ISO-8859-1 but there are still a few odd characters when viewed as that encoding as well.

**spence_noodle** · May 13, 2009, 13:18

He needs to tell mysql query which text encoding he will be using and to do this just place this before any insert and update:

Code MySQL:

// Set Names to utf8
mysql_query("SET NAMES 'utf8'");

Where 'utf8' is, this can be changed to whatever you want, e.g. 'ISO-8859-1'.

The SitePoint Forums have moved.

User Tag List

Thread: Unknown character display

Thread Tools

Display

Unknown character display

Bookmarks

Bookmarks

Posting Permissions