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 '
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 '