Comments - Adding a latin name to a larin1 column works on 10.4, doesn't work on 10.5

Latin Small Letter L with Stroke does not exists in latin1.

MariaDB can do two things when an impossible character gets written to a column:

- Issue a warning (the character gets replaced to the question mark in this case)

- Issue an error

The choice between the warning and the error is made according to:

- STRICT_TRANS_TABLES flag in sql_mode

- STRICT_ALL_TABLES flag in sql_mode

- The engine used.

It seems that after switch from 10.4 to 10.5 either of them have changed.

Please check the output of this script in both installations:

SELECT @@sql_mode;
SHOW CREATE TABLE <tablename>;