MYSQL + PHP试图插入IPA字符

Question

I'm having an issue inserting phonetic pronunciations into my database. Here's some images showing what I've done, and the result at the end.

Here's my table layout :

I've added the header on the file that I'm running the script on :

On the web page, the encoding is fine :

Here's how it's uploaded into the database :

Thanks guys please give me some insight on what I'm doing wrong. I'm using phpmyadmin, and on the column for the ipa I'm using utf8mb4_bin

Answer 1

I've solved it myself, because I'm using PDO I simply added charset=utf8 to the connection string

$DB = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8",$user,$pass);