DEV Community

Discussion on: varchar(n) - how big should n be?

Collapse
 
alexanderjanke profile image
Alex Janke

To be honest, just limit it to your personal upper limits. A varchar(2) uses virtually the same amount of space as a varchar(200) if your input string is the same. The number in the brackets pretty much acts as a restriction.

Check out this page from the postgre docs for a way more detailed explanation:
postgresql.org/docs/9.3/datatype-c...