> Infrastructure engineers generally care most about [...] never, ever, losing data. Does MySQL still silently truncate varchar columns when the inserted text is too long?
No, it throws an error letting you the the text is too long for the field
Why infrastructure engineers prefer MySQL
11–13 of 13 posts
Re: Why infrastructure engineers prefer MySQL
#12> Infrastructure engineers generally care most about [...] never, ever, losing data. Does MySQL still silently truncate varchar columns when the inserted text is too long?
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.
Re: Why infrastructure engineers prefer MySQL
#13> Infrastructure engineers generally care most about [...] never, ever, losing data. Does MySQL still silently truncate varchar columns when the inserted text is too long?
Not for a very long time, look up strict mode.