如何更改列以支持unicode

Question

I have created a simple database table called players:

CREATE TABLE player (
    id              int(10)
                    NOT NULL
                    AUTO_INCREMENT
                    PRIMARY KEY,

    name            varchar(256)
                    NOT NULL
);

ALTER TABLE  players
    CHANGE name name
        varchar(256)
        CHARACTER SET utf8mb4
        COLLATE utf8mb4_unicode_ci;

I want to insert this entry into the database '

Answer 1

As discussed over the comments : you have correctly altered your table so the name column accepts utf8 characters.

In this MySQL 5.7 DB Fiddle, string '