mysql insert turns ★ into â˜…

Question

When I do an insert from my application all ★ (stars) turns into "â˜…"

How can I stop this from happening?

*It works if I directly insert it through phpmyadmin, but not when doing it using this php:

<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

$inputTime = mysql_escape_string($_POST['inputTime']);
$inputBotid = mysql_escape_string($_POST['inputBotid']);
$inputImage = mysql_escape_string($_POST['inputImage']);
$inputName = mysql_escape_string($_POST['inputSkin']);
$inputStatus = mysql_escape_string($_POST['inputStatus']);
$inputTradeid = mysql_escape_string($_POST['inputTradeid']);

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "INSERT INTO items (trade, market_hash_name, status, img, botid, time)
VALUES ('$inputTime', '$inputName', '$inputStatus', '$inputImage', '$inputBotid','$inputTime')";

if ($conn->query($sql) === TRUE) {
    echo "Success";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

Check the database's collation and how you insert the data. And read this: http://www.joelonsoftware.com/articles/Unicode.html — Bart Friederichs, Nov 28 '16 at 08:49

score 0 · Accepted Answer · edited May 23 '17 at 12:07

0

You have Mojibake. Search this Q&A for 'Mojibake' to see what causes and how to prevent it.

Since you are into symbols, you might want to use utf8mb4, not just utf8 in MySQL. The former includes various 4-byte Emoji.

Also, see PHP tips. The most important is $mysqli_obj->set_charset('utf8mb4'); right after connecting.

edited May 23 '17 at 12:07

Community

1
1

answered Nov 28 '16 at 20:32

Rick James

135,179
13
127
222

mysql insert turns ★ into â˜…

1 Answers1