phpmyadmin Question posted in
The official documentation can be found here.

MYSQL + PHP trying to insert IPA characters – Phpmyadmin

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 :

enter image description here

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

enter image description here

On the web page, the encoding is fine :

enter image description here

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

enter image description here

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

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    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);

  2. 0

    I would make sure that the connector is also set to utf8mb4:

    e.g. $this->con->set_charset("utf8mb4");

    But most of your answers should be here:

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search