rodry has asked for the wisdom of the Perl Monks concerning the following question: ⭐ (database programming)
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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: MySQL: BLOB/TEXT vs multiple VARCHAR columns⭐
by athomason (Curate) on Aug 19, 2000 at 04:59 UTC | |
Re: MySQL: BLOB/TEXT vs multiple VARCHAR columns
by lachoy (Parson) on Oct 15, 2000 at 02:01 UTC | |
Re: MySQL: BLOB/TEXT vs multiple VARCHAR columns
by cianoz (Friar) on Oct 15, 2000 at 14:39 UTC |