0

Database informations_schema - enter image description here This My Code

// Create connection 
$conn = mysqli_connect($servername, $username, $password, $dbname);

 // Check connection 
if (!$conn) { 
    die("Connection failed: " . mysqli_connect_error()); 
} 
$sql = "UPDATE table1 SET authorname='日本Delphi振興会 ヤマト運輸' WHERE id='1'"; 
$sql1 = mysqli_query($conn, $sql);

Database record is update successfully.

But data stored is garbage enter image description here

What could be the problem?

Rick James
  • 135,179
  • 13
  • 127
  • 222
Tushar Korat
  • 591
  • 2
  • 7
  • 21
  • https://stackoverflow.com/questions/1287252/mysql-insert-japanese-from-php-encoding-troubles?rq=1 – Pradeep May 23 '18 at 14:23
  • That's [_Mojibake_](https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored) – Rick James May 28 '18 at 20:48
  • This question is not a dup of https://stackoverflow.com/questions/6006791/utf8-and-japanese-characters -- This is Mojibake, that is Question Marks. – Rick James May 28 '18 at 20:49

0 Answers0