I would like to know which is better
Postgres Varchar(70) or text which is better
varchar(10) or text varchar(70) or text
Asked
Active
Viewed 32 times
0
-
That's not a question of "better". If you have a business requirement to limit the number of characters to 10 or 70 you have to use `varchar(10)` or `varchar(70)`. If you don't have such requirement, then `text` will do. The limit on a varchar column is not something "technical" is a constraint that ensures the correctness of your data. – Nov 09 '22 at 06:50