Hacker News new | ask | show | jobs
by tlhunter 1620 days 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?

4 comments

See, 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.
Long 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.
No, it throws an error letting you the the text is too long for the field
Not for a very long time, look up strict mode.