Re:Why do database columns have a character length of 191?
by ChrisSD on Tuesday May 18, 2021 @12:33AM
(#27191280)
Interestingly, this was a mistake even the creators of UTF-8 wanted to make
> The 4, 5, and 6 byte sequences are only there for political reasons. I would prefer to delete these
Obviously 5 and 6 byte sequences are consigned to history but 4 byte sequences turned out to be useful for more than "political reasons".
http://doc.cat-v.org/bell_labs/utf-8_history
(scroll right to the bottom)
This is upsetting because until recently if you asked for a utf8 column, this is what you got instead. You got something which was almost, but not quite compatible with utf8.