Remove Bytes Remove Database-centric Remove MySQL Remove Relational Database
article thumbnail

Why are database columns 191 characters?

Grouparoo

In this post, we’ll look at the historical reasons for the 191 character limit as a default in most relational databases. The first question you might ask is why limit the length of the strings you can store in a database at all? Why varchar and not text ? s fault 255 makes a lot more sense than 191. How did we get to 191?