I'm having a weird problem ,not sure what the title should be and I searched before posting this ,the collation of my database is set to utf8mb4_general_ci
and so is the column,
yet when I type into the text field of that column the php code saves it just fine,how ever when this special text is copied from somewhere the column stays empty !
I already have this set in my code
$this->connection = new mysqli(HOST, USER, PASS, DB);
$this->connection->set_charset('utf8mb4');
You should use the following function before inserting it into database ,in which input_data is the data which you want to store in database . And the problem is database dont allow special character , and mostly these character are use for SQL injection , so this function do the cleaning stuff by escaping ,so the data is safe to save.
follow this link for documentation mysqli::real_escape_string