Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

8
  • 36
    A bit old, but I came here because I ran into a problem that made me think about this. In my case my front-end form was limited to 2,000 characters but the encoding implicit in my storage method encoded international characters as multiple characters (which can apparently anywhere from 3 - 12 per character). So my 2,000 suddenly becomes up to 24,000. Something to think about... Commented Mar 24, 2014 at 22:40
  • 3
    I have found text to be significantly faster for many concurrent inserts. Commented Mar 28, 2014 at 8:47
  • 13
    @RickJames consider posting an updated answer, rather than close the question Commented Jun 24, 2018 at 2:19
  • 4
    @YvetteColomb - I added an Answer. I would mainly like to get rid of the Accepted Answer because it is out of date. I came to the Q&A because someone was quoting incorrect info, saying "754 upvotes, so it must be right". OK, I edited the Approved answer, too. (Though that feels improper.) Commented Jun 25, 2018 at 16:09
  • 2
    MySQL :: MySQL 8.0 Reference Manual :: 15.10 InnoDB Row Formats Commented Apr 17, 2020 at 3:10