By maynard on

OK, so I'm considering drupal or scoop for a personal pet project. One problem that I have is that some of the written content I wish to present is large, well over 64KB in length, which would exceed the mysql default TEXT record length. While I realize that I could just change this to another value - 256KB for example - I'd still be limited to a size of that value. What if I needed more for certain projects and less for others? I'm caught in a bind of not having enough for some and wasting space for others.

So, my question is: can drupal automatically break up and link multiple data records to present a single piece of unified text (a story submission, for example)? Thanks! --M

Comments

maynard’s picture

maynard commented

OK. After playing with a drupal install I see this is not a problem. Please disregard this posting. --M

Steven’s picture

Steven commented

Drupal's MySQL schemes use large text types (LONGTEXT), while PostgreSQL's TEXT type is large by default. They both support up to 4GB of data, that should be enough ;).

Both fields adjust their size to the actual content, so you don't need to be afraid of a bloated database. For MySQL, the difference between a TEXT and LONGTEXT field is just 2 bytes in length.

In fact, for Drupal, the most limiting factor is usually the PHP memory limit, set in php.ini. For large sites with lots of modules you might need to enlarge it.

--
If you have a problem, please search before posting a question.