[NavinF]

It doesn't block inserts with invalid data? I thought that was the whole point of telling the database what types you're using

[dpcx]

MySQL historically isn't very good about blocking bad data. Sometimes it would silently truncate strings to fit the column type, for example. It's getting better as time goes on, though.

[ilyt]

It does and poster above is incompetent

[eurasiantiger]

I have had customer production sites go down due to this issue when emojis first arrived. It was a common issue in 2015. I would hope it is fixed by now!