Can't set utf8 charset in PHP

Question

This is my php file :

<?php
  define('HOST','localhost');
  define('USER','myUser');
  define('PASS','myPass');
  define('DB','myDb');
  $con = mysqli_connect(HOST,USER,PASS,DB);
  $text = $_POST['text'];
  $name = $_POST['name'];
  $subject = $_POST['subject'];
  mysqli_set_charset($con,"utf8");
  $sql = "insert into someTable (email,text,name,subject) values ('$email','$text','$name','$subject')";
  if(mysqli_query($con,$sql)){
     echo 'Sent successfully';
  }
  else{
     echo 'Unexpected error';
  }
  mysqli_close($con);
?>

I'm sending some values from my android app to this php backend and this code will save my values to MySQL database.

It's working perfect but if i send values in non english language it shows values like this:

I've already set MySQL collation on UTF-8 and I think the problem is from my php backend

EDIT:

I also tried solutions in this topic but it's not working.

What is the charset (not collation) of you database table? collation is used for sorting data, charset is used for storing data — Mark Baker, Aug 31 '16 at 11:55
Possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Gerard Roche, Aug 31 '16 at 11:56
Look at the table definition: `SHOW CREATE TABLE myTableName` — Mark Baker, Aug 31 '16 at 12:58

score 3 · Answer 1 · edited Dec 22 '17 at 00:08

3

You had to set the collection to utf8Persian-ci. Of course I also had a problem like yours, please refer to this Link, I hope that can help you :)

edited Dec 22 '17 at 00:08

no id

1,642
3
24
36

answered Dec 21 '17 at 21:41

Azade

359
2
15

Can't set utf8 charset in PHP

1 Answers1