Re:Why do database columns have a character length of 191?
by jzelinskie on Monday May 17, 2021 @04:00PM
(#27187718)
It's true that Postgres does this. But the problem I was highlighting was the developer-error of lacking to explicitly declare an encoding. It's only really related to the OP link insofar-as when you fail to do so on MySQL, you'll receive error messages that inform you of the dreaded 767-byte index.
[ Parent
| on HN ]
Re:Why do database columns have a character length of 191?
by masklinn on Monday May 17, 2021 @04:11PM
(#27187856)
You can actually have a similar error in postgres, it's just that the index limit is at 2730 bytes, and it's unlikely you'll have indexed a column which can get content more than 2.5k.
It does happen though, as I've discovered (repeatedly, because I'm a slow learner).