5 ms·
> Infrastructure engineers generally care most about [...] never, ever, losing data. Does MySQL still silently truncate varchar columns when the inserted text
by tlhunter 5y ago
> Infrastructure engineers generally care most about [...] never, ever, losing data.
Does MySQL still silently truncate varchar columns when the inserted text is too long?
- ncmncm 5y agoSee, that doesn't affect infrastructure engineers at all. It's "working as designed", howsoever bad the design is, so they get no calls about it.
- auspex 5y agoNo, it throws an error letting you the the text is too long for the field
- forinti 5y agoLong time ago I was debugging an application and realised MySQL would let me put anything in a column that was supposed to be numeric. It didn't even check the length constraint.
- xdfgh1112 5y agoNot for a very long time, look up strict mode.