A column's type decides which values it accepts, what each costs on disk and in every index, and how values compare and sort. MySQL 524 is full of surprises here, rounding or converting some bad values with a mere note, so every result below comes from MySQL 9.7.2 in its default strict sql_mode (SQL Modes and Strict Mode), run against the shop database and a few test tables.