3 ms·
We had similar experiences, and now use varchar 99, varchar 999, varchar 9999. The purpose of the "9" digits is to highlight that it's our plausible guesstimate
by jph 5y ago
We had similar experiences, and now use varchar 99, varchar 999, varchar 9999. The purpose of the "9" digits is to highlight that it's our plausible guesstimate for "good enough" and can be increased later, rather than any definite unchangeable limit.
- brandur 5y agoNice — I like the idea of the "9" convention. It serves to catch the eye (9s are positively _harsh_ compared to other numbers) and show that it's meant more as a ballpark rather than a precisely chosen number for this specific field.