PHP & MySQL - Problems with UTF-8 encode

Question

I have a form with a input that accept UTF-8 characters:

<form method="post" action="faz-personagem.php" accept-charset="UTF-8">
  <div class="row">
    <label for="nome">Nome</label>
    <input type="text" name="nome">
  </div>
  ...
  <button type="submit">Enviar</button>
</form>

And a script that send the data to a database:

<?php

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

$conexao = mysql_connect('localhost', 'root', 'pass');
mysql_select_db('pan-tactics');

$nome   = $_POST['nome'];

$nome = utf8_encode($nome);

$sql = "INSERT INTO personagens VALUES";
$sql .= "('$nome')";

$resultado = mysql_query($sql);

echo 'Personagem criado com sucesso.';

mysql_close($conexao);

?>

I also have specified in the creation of the database the collation utf8_unicode_ci and yet what I get is wrong special characters:

What can I do to fix it?

gvlasov · Accepted Answer · 2023-06-26 12:01:48Z

2

Keep in mind that collation is not the same as charset. You need to set your database and table to be in UTF-8 encoding. This can be done with running this SQL command (only need to be done once).

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Furthermore, you should set the mysql_* connection to UTF-8. This code should be placed directly after connecting to your database:

mysql_set_charset("utf8");

I see you already set the PHP header to UTF-8 as well, so that's good.

Keep in mind that usage of mysql_* functions are deprecated and no longer maintained; you should switch to PDO or MySQLi for security reasons.

If neither of these steps helped you, you may need to save the document itself as UTF-8 w/o BOM, this can be done in Notepad++ as Format -> Convert to UFT-8 w/o BOM.

edited Jun 26, 2023 at 12:01

gvlasov

20.3k22 gold badges85 silver badges120 bronze badges

answered Aug 16, 2015 at 17:10

Qirel

26.6k7 gold badges54 silver badges71 bronze badges

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

1 Comment

Qirel Over a year ago

Glad to have helped! Keep in mind though, that all aspects of your applications and scripts should be set to the same charset, so doing all those things above certainly wouldn't hurt!

Markus Weiß · Accepted Answer · 2022-03-09 12:43:19Z

2

i had the same problem.

This was my solution:

$con = mysqli_connect('localhost', 'secretuser', 'secret', 'mydb');
mysqli_set_charset($con, "utf8mb4");

in your case:

$conexao = mysql_connect('localhost', 'root', 'pass');
mysqli_set_charset($conexao, "utf8mb4");

Maybe this will help someone who comes across this old post.

answered Mar 9, 2022 at 12:43

Markus Weiß

215 bronze badges

Comments

Frank B · Accepted Answer · 2015-08-16 17:10:12Z

0

Set your connection with the database to utf-8: mysql_set_charset http://php.net/manual/en/function.mysql-set-charset.php

U should use mysqli_ functions or PDP rather then mysql_ functions!

answered Aug 16, 2015 at 17:10

Frank B

3,7071 gold badge19 silver badges23 bronze badges

Comments

destraaaa · Accepted Answer · 2015-08-16 17:12:39Z

0

Check your collation of your database (including columns and tables). Also, try adding mysql_query("set names 'utf8'"); after the connection to database in your code.

answered Aug 16, 2015 at 17:12

destraaaa

965 bronze badges

Comments

Rick James · Accepted Answer · 2015-08-28 05:37:29Z

0

Were you expecting João for the first name? If so, you have "Mojibake".

JoÃƒÂ£o is even worse -- It looks like you Mojibaked João to get JoÃ£o, then Mojibaked that to get JoÃƒÂ£o.

answered Aug 28, 2015 at 5:37

Rick James

144k15 gold badges144 silver badges255 bronze badges

Collectives™ on Stack Overflow

PHP & MySQL - Problems with UTF-8 encode

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related