Simplest way to do it is, utf8mb4 stores all the symbols ALTER TABLE AsinBuyBox CONVERT TO CHARACTER SET utf8mb4;