Problem with PHP and Mysql UTF-8 (Special Character)

Question

I Have a form with one textbox called(ProductTitle)

if I write as example "Étuit" in the textbox and click on Save, I post the data in a table called Product. The result int the database for ProductTitle is Ã‰tuit. My concern is about the Special character. Instead of putting É in the database , I got that Ã‰

When I Load the Product Title ("Étuit") from the database into a span. That show correctly.
BUT When I load it inside a Textbox to Edit the Product Title, that show Ã‰tuit.

Anybody know why.

I Put that in the html head

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

Note : When I Click save on the form, the data is posted with jquery ajax method.

@Jean-Francois There's nothing "special" about the character "É". Also, please review the currently accepted answer. It is wrong. — deceze
– deceze ♦, Commented Aug 16, 2011 at 5:06

Pedro Lobito · Accepted Answer · 2011-08-16 04:48:51Z

12

Try seting the client encoding before using the DB.

mysql_query("SET NAMES 'utf8'");

If the above doesn't work use the utf8 encode/decode functions:

<?
$string ="Étuit";
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<?
echo $string; // echo's '?tuit'
echo utf8_encode($string); // echo's 'Étuit'
?>

edited Aug 16, 2011 at 4:48

answered Aug 16, 2011 at 3:52

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

deceze Over a year ago

Either or. If you set everything to UTF-8, there's no need for utf8_encode. Do you know what this function actually does?

Pedro Lobito Over a year ago

deceze : it encodes a string to utf8. Nice picture you've on your profile ;)

deceze Over a year ago

But the string is already encoded in UTF-8, at least it's supposed to be! While you're on my profile, please click through to the long ranty article I wrote about encodings, which goes through this in more detail.

SeanCannon Over a year ago

@deceze you're taking this function way too personally and come across as a douche with all the righteous downvoting.

SeanCannon Over a year ago

For starters, stop being so condescending. Instead of "...do you know what this function actually does?" you could say "According to the PHP docs, the function actually...and you you can replicate that behavior like..."

|

Georg Plaz · Accepted Answer · 2020-09-10 13:00:32Z

10

Take a look at utf8_encode() and utf8_decode(). Also take a look at multibyte string functions.

edited Sep 10, 2020 at 13:00

Georg Plaz

6,0285 gold badges44 silver badges66 bronze badges

answered Aug 16, 2011 at 3:42

SeanCannon

78.1k17 gold badges126 silver badges145 bronze badges

5 Comments

deceze Over a year ago

Sorry, but unless you can explain what utf8_encode actually does and why this would be better than @gview's solution, I'll have to give you a -1.

deceze Over a year ago

Try saving the text "エンコード" into your UTF-8 database (which should be able to handle it, right?) using utf8_encode/utf8_decode and tell me if it's still working.

Jean-Francois Over a year ago

I don't need these character. I Only need French character like éè .

deceze Over a year ago

@Jean-Francois Maybe, but using this solution you're either storing garbage in the database or are replacing any characters that are not part of the latin-1 encoding with question marks, depending on whether you first utf8_encode then decode or vice versa. Maybe that doesn't bother you now because you just happen to only be using latin-1 encodable characters, but a) you're not handling UTF-8 correctly by doing so and b) it may come back to bite you one day. To handle UTF-8 correctly, set your database connection to UTF-8 as explained by @gview.

Jean-Francois Over a year ago

Thanks deceze, I configured my database correctly. You absolutely right. Do thing properly paid one day :)

gview · Accepted Answer · 2011-08-16 03:59:14Z

9

Probably what is happening is that the default character set for the client is not set to UTF-8, so you're getting tranposition in one direction or the other. This is covered in a number of different ways here:

Often an initialization query of "SET NAMES utf8" just after the connection is instantiated will solve the issue going forward but make sure that what you think is stored (utf8) is actually what was stored. You might have a cleanup job if not.

answered Aug 16, 2011 at 3:59

gview

15.5k3 gold badges53 silver badges56 bronze badges

3 Comments

Jean-Francois Over a year ago

The problem here, is all the answer work really good, it's hard to find who got the best answer. I Use Doctrine , and it's not necessary to apply Set Name on mysql_query. Thanks for your help too

gview Over a year ago

Jean-Francois, you might want to go back and edit your question to indicate that Doctrine was involved. It would have been helpful information. Are you configuring your connection using $manager->setCharset('utf8'); It would be good to know how this was ultimately handled for future reference.

yunusual Over a year ago

As the guide in @gview's link suggests, setting the html form attribute "<form accept-charset="utf-8">" solved the OP's issue for me.

Zon · Accepted Answer · 2013-11-03 13:36:35Z

0

Not to bother with SET NAMES before every connection in the code, a parameter in mysql connection string can be used:

"jdbc:mysql://hostAddress:port/databaseName?characterEncoding=UTF-8"

answered Nov 3, 2013 at 13:36

Zon

20k8 gold badges99 silver badges104 bronze badges

Comments

Dmitry Pavlov · Accepted Answer · 2014-04-17 15:32:53Z

0

This post explains how to configure and work with UTF-8 in PHP and MySQL. Hope that saves your time.

A UTF-8 Primer for PHP and MySQL

answered Apr 17, 2014 at 15:32

Dmitry Pavlov

28.6k7 gold badges102 silver badges131 bronze badges

Comments

lmcDevloper · Accepted Answer · 2016-02-10 22:03:12Z

0

These work for me:

In the HTML headers:

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

After the PHP connection:

$conexion = @mysql_connect($servidor, $usuario, $contrasenha);
mysql_select_db($BD, $conexion) or die(mysql_error($conexion));
mysql_query("SET NAMES 'utf8'");

answered Feb 10, 2016 at 22:03

lmcDevloper

3322 silver badges8 bronze badges

Comments

Samuel Corradi · Accepted Answer · 2017-08-22 22:54:44Z

0

I just use set_charset method when i'm using mysqli lib.

error_reporting(E_ALL);

$mysqli = new mysqli('localhost', 'login', "pass", 'database');

if ( ! $mysqli->set_charset("utf8") )
{
   printf("Error loading character set utf8: %s\n", $mysqli->error);
}

answered Aug 22, 2017 at 22:54

Samuel Corradi

493 bronze badges

Comments

Fatimaezzahra Rarhibou · Accepted Answer · 2018-08-18 02:37:24Z

0

I also had difficulties with this, but the following always works for me ! Before manipulating your data, make sure to set the encoding as follows:

try{
  $dbh = new PDO($dsn, $user, $pass);
  $dbh->query("SET NAMES 'utf8'");
  print "Connected";
 }

catch(PDOException $e){
  print "Error!!   " . $e->getMessage()."<br/>";
  die();
 }

edited Aug 18, 2018 at 2:37

answered Aug 18, 2018 at 2:10

Fatimaezzahra Rarhibou

4491 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

Problem with PHP and Mysql UTF-8 (Special Character)

8 Answers 8

8 Comments

5 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

8 Comments

5 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related