News for hackers. Stuff that matters.

A comment on Why infrastructure engineers prefer MySQL.

Re:Why infrastructure engineers prefer MySQL by tlhunter on Tuesday January 18, 2022 @01:15AM (#29975746)
> Infrastructure engineers generally care most about [...] never, ever, losing data.

Does MySQL still silently truncate varchar columns when the inserted text is too long?

[ Parent | on HN ]
Re:Why infrastructure engineers prefer MySQL by ncmncm on Tuesday January 18, 2022 @02:32AM (#29976184)
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.
[ Parent | on HN ]
Re:Why infrastructure engineers prefer MySQL by forinti on Tuesday January 18, 2022 @07:53AM (#29978277)
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.
[ Parent | on HN ]
Re:Why infrastructure engineers prefer MySQL by auspex on Tuesday January 18, 2022 @06:33AM (#29977694)
No, it throws an error letting you the the text is too long for the field
[ Parent | on HN ]
Re:Why infrastructure engineers prefer MySQL by xdfgh1112 on Tuesday January 18, 2022 @02:50PM (#29984731)
Not for a very long time, look up strict mode.
[ Parent | on HN ]