How to INSERT & Symbol in MySQL?

Question

I'm inserting a CSV File into a MySQL Table. One row of the CSV file has a name with & Symbol like this:

Peter & Peter

Shortly befor the Database Insert, the echo-statement of $Variable gives "Peter & Peter" and until here, String looks fine. But after the Insert, Database shows:

Peter & Peter 

How can I INSERT "&"-Symbol into Database?

After Database Connection, I indicate all possible settings to UTF8:

# Database Connection here
$mysqli->query("SET NAMES 'utf8'");
$mysqli->set_charset("utf8");
$charset = $mysqli->character_set_name();
printf ("Current character set is %s\n", $charset);

Database parameters:

• Current character set is utf8
• Column type is varchar(200)
• The DB-Table is "utf8_general_ci" and
• all Fields of the Table are also set to Collation "utf8_general_ci"

How can I INSERT "&"-Symbol into Database?

Answer 1

INSERT INTO (field) VALUES ('&');