I have the following scenario (which you may be familiar with:

An online periodical is needed, similar in fashion to Slashdot and others. I suggested the best solution for it to be PERL/MySQL given the available resources ($).

Doing research I on development of similar sites I notice that one way to store an article/news text was to create several VARCHAR columns with the maximun of 255 characters for each one. The author would then break up the text to be posted into several chunks, 255 character long.

Then, upon reading the MySQL documentation in more detail, I noticed that it supports BLOB/TEXT column types that seemed to be specially suited for the kind of application I am dealing with.

So, the obvious question is, which is the preffered way to attack such problem. Or better yet, what are the pros and cons of each approach.

Thank you Monks.

Originally posted as a Categorized Question.

In reply to MySQL: BLOB/TEXT vs multiple VARCHAR columns by rodry

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.