Why does the request fail because of the foreign key?

Question

Java

Client database:

Gender database:

I am running a query:

INSERT INTO client (FirstName, LastName, Patronymic, Birthday, RegistrationDate, Email, Phone, GenderCode, PhotoPath) VALUES ('111', '111', '111', '1999-10-10', '2021-04-14 09:54:49', '111', '111', 'м', '111')

Error:
Cannot add or update a child row: a foreign key constraint fails (`demotest`.`client`, CONSTRAINT `FK_Client_Gender` FOREIGN KEY (`GenderCode`) REFERENCES `gender` (`Code`) ON DELETE NO ACTION ON UPDATE NO ACTION)

I execute queries like this:

public static ResultSet executeQuery (String sql) {
        ResultSet resultSet = null;
        System.out.println(sql);
        try {
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            if (sql.contains("SELECT")) {
                resultSet = preparedStatement.executeQuery();
            } else {
                preparedStatement.executeUpdate();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();

        }
        return resultSet;

    }

Why does such an error occur?

Answer 1

You don't have an entry in the gender table with Code = 'm'.
Therefore, the write restriction to the associated GenderCode field is triggered.

Answer 2

I suspect glitches with encodings. Does it work in prog-admin?