SET NAMES utf8;

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a ENUM('a','b','?','.') CHARACTER SET latin1);

INSERT INTO t1 VALUES ('ÿ'),('я');

SHOW WARNINGS;

SELECT * FROM t1;

MariaDB [test]> SET NAMES utf8;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> DROP TABLE IF EXISTS t1;

Query OK, 0 rows affected (0.12 sec)

MariaDB [test]> CREATE TABLE t1 (a ENUM('a','b','?','.') CHARACTER SET latin1);

Query OK, 0 rows affected (0.32 sec)

MariaDB [test]> INSERT INTO t1 VALUES ('ÿ'),('я');

Query OK, 2 rows affected, 1 warning (0.03 sec)

Records: 2  Duplicates: 0  Warnings: 1

MariaDB [test]> SHOW WARNINGS;

+---------+------+----------------------------------------+

| Level   | Code | Message                                |

+---------+------+----------------------------------------+

| Warning | 1265 | Data truncated for column 'a' at row 1 |

+---------+------+----------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> SELECT * FROM t1;

+------+

| a    |

+------+

|      |

| ?    |

+------+

2 rows in set (0.00 sec)