Re:Old, Good Database Design
by nemothekid on Monday September 14, 2020 @04:40PM
(#24474876)
For what I understand in the docs, in postgres at least, VARCHAR and TEXT are the same thing, and CHAR actually has the performance hit.
[ Parent
| on HN ]
Re:Old, Good Database Design
by colanderman on Monday September 14, 2020 @04:53PM
(#24475022)
They are implemented the same, but they aren't the same type. Notably, each parameterization of varchar (or char) is its own type. This can cause issues when trying to change the length parameter. For this reason I prefer to use TEXT with a CHECK constraint.