UTF-8 not working in HTML forms

Question

I have this form:

<form method="post" enctype="multipart/form-data" accept-charset="UTF-8">

But when I submit an é character, it turns it into Ã©.

Why doesn't this work? Yes, the MySQL database has all the character-sets set up correctly. (Database, tables.) If I manually put it in the database with Navicat it shows up fine on the webpage.

Also, I have tried the metatag, setting the content-type header, without success.

How are you putting the form data into the database? Is your server side language preserving UTF-8? — Oded, Sep 02 '10 at 07:37
Are you serving your page as UTF-8 when you display it back to the user? Check that your meta tags and headers match. — davidtbernal, Sep 02 '10 at 07:38
All fields go through mysql_real_escape_string, and are then put in the database using this query: mysql_query("UPDATE `users` SET `Profile`='".$newProfile."',`Avatar`='".mysql_real_escape_string($avatar)."' WHERE `ID`=".$thisUser['ID']); — Codecat, Sep 02 '10 at 07:38
notJim: the Ã© also appears in the database itself, which means that the clients are not sending it correctly, and thus a problem with either HTML or PHP that's not doing it right. — Codecat, Sep 02 '10 at 07:40
Please edit your question and add these details to the question, instead of a comment. — Oded, Sep 02 '10 at 07:40
When you say "appears in the database itself", which mysql client are you using to see that? I've encountered issues with utf-8 values in various clients including Mysql Query Browser. If you select the value back into php, with utf-8 headers et al properlty set, does it display it garbled? — Fanis Hatzidakis, Sep 02 '10 at 09:40

shamittomar · Accepted Answer · 2010-09-02T08:07:24.207

9

In your HTML, add this meta tag:

 <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">

Also add this PHP header at top of the script:

 header("Content-Type: text/html;charset=UTF-8");

[EDIT]:

One more tip is to save the file as UTF-8 without BOM encoding. You can use Notepad++ or any decent editor to do that.

edited Sep 02 '10 at 08:07

answered Sep 02 '10 at 07:43

shamittomar

46,210
12
74
78

3

Have both, doesn't change anything. – Codecat Sep 02 '10 at 07:55
Do you have the `header` at the top in the HTML page where the form is ? – shamittomar Sep 02 '10 at 07:58
@angelo, what do you mean by *extra characters* ? Also, I have updated my answer. – shamittomar Sep 02 '10 at 08:07
2

@shamittomar, I did that because only "Yes" is a too short comment :) – Codecat Sep 02 '10 at 08:12
Also, the database CAN contain the correct characters, and CAN return the correct characters, which the page can display correctly. It really is PHP that's not sending it correctly (or the browser) – Codecat Sep 02 '10 at 08:28
So, did you save it with `UTF-8 without BOM` ? – shamittomar Sep 02 '10 at 11:50

score 2 · Answer 2 · answered Oct 27 '19 at 15:49

2

Had the exactly same problem as mentioned above, tried everything mentioned. Try deleting enctype="multipart/form-data" and adding accept-charset="utf-8" from the tag. This was the solution in my case.

answered Oct 27 '19 at 15:49

Tom Friedrichs

23
5

score 1 · Answer 3 · answered Sep 02 '10 at 07:42

1

Ensure you have set your connection collation to utf8:

SET NAMES utf8

answered Sep 02 '10 at 07:42

aularon

11,042
3
36
41

Is the form page utf-8 as well? Also, did you try another browser/machine? – aularon Sep 02 '10 at 08:04
I just tried Internet Explorer, same problem. Other users also experience this problem. – Codecat Sep 02 '10 at 08:27

score 0 · Answer 4 · answered Jan 18 '19 at 14:30

0

Add only accept-charset="character_set" in form. It is all!

accept-charset="character_set"

answered Jan 18 '19 at 14:30

Ivan Pirus

1,026
11
21

UTF-8 not working in HTML forms

4 Answers4

Linked

Related