Y
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
ncmncm
1620 days ago
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.
link
forinti
1620 days ago
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.
link
auspex
1620 days ago
No, it throws an error letting you the the text is too long for the field
link
xdfgh1112
1619 days ago
Not for a very long time, look up strict mode.
link