<?xml version="1.0" encoding="windows-1252"?>
<node id="28609" title="MySQL: BLOB/TEXT vs multiple VARCHAR columns" created="2000-08-18 22:01:04" updated="2005-08-15 09:06:25">
<type id="1857">
categorized question</type>
<author id="11732">
QandAEditors</author>
<data>
<field name="doctext">
I have the following scenario (which you may be familiar with:
&lt;p&gt;
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 ($).
&lt;p&gt;
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.
&lt;p&gt;
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.
&lt;p&gt;
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.
&lt;p&gt;
Thank you Monks.
</field>
<field name="parent_node">
1831</field>
</data>
</node>
