Switching a field type from Checkbox to Lightswitch causes MySQL error about data truncation

[angrybrad]

Environment:

• Craft version: 3.x
• PHP version: 7.x
• Database driver & version: MySQL - Need to verify behavior in PostgreSQL
• Plugins & versions:

Description:

Switching a field type from Checkbox to Lightswitch causes MySQL error about data truncation.

Steps to reproduce:

Change a field with data in it from a Checkbox to a Lightswitch.

[angrybrad]

Maybe come up with a way for field types to be notified when their type changes. Also maybe a the concept of "convertible/compatible" data types for field types when changing.