Code: Select all
// Maximum message length check. 0 disables this check completely.
if ((int) $config['max_' . $mode . '_chars'] > 0 && $message_length > (int) $config['max_' . $mode . '_chars'])
{
$this->warn_msg[] = $user->lang('CHARS_' . strtoupper($mode) . '_CONTAINS', $message_length) . '<br />' . $user->lang('TOO_MANY_CHARS_LIMIT', (int) $config['max_' . $mode . '_chars']);
return (!$update_this_message) ? $return_message : $this->warn_msg;
}
So for single byte characters, that is a maximum of 16,000,000 without changing the schema.Marshalrusty wrote:EDIT: Looks like we use 'mediumtext', which is quite a bit larger at 16 Megabytes.
every password dump ever!Marshalrusty wrote:So for single byte characters, that is a maximum of 16,000,000 without changing the schema.Marshalrusty wrote:EDIT: Looks like we use 'mediumtext', which is quite a bit larger at 16 Megabytes.
An average book (250 words per page with 300 pages) has roughly 500,000 characters. 100,000,000,000,000 / 500,000 = 200,000,000, or the Library of Congress 10 times over.
What do you have that's 100,000,000,000,000 characters long?
It was hyperbole.Marshalrusty wrote:So for single byte characters, that is a maximum of 16,000,000 without changing the schema.Marshalrusty wrote:EDIT: Looks like we use 'mediumtext', which is quite a bit larger at 16 Megabytes.
An average book (250 words per page with 300 pages) has roughly 500,000 characters. 100,000,000,000,000 / 500,000 = 200,000,000, or the Library of Congress 10 times over.
What do you have that's 100,000,000,000,000 characters long?
EDIT: Not to mention that's 100 terabytes worth of text.
That depends on what you change it to, which depends on which rdbms you're using and how it's configured. Also on the available storage space.Chuckster555sf wrote:My post is more like 100,000,000. What's the maximum after changing the schema?
actually, there are other things at play here:Marshalrusty wrote:That depends on what you change it to, which depends on which rdbms you're using and how it's configured. Also on the available storage space.Chuckster555sf wrote:My post is more like 100,000,000. What's the maximum after changing the schema?
I believe that the max for longtext is 4 Gigabytes.
So that's still about 200 books if Rusty's numbers are correct. I'm curious what you would post that is that long and if you actually expect users to read it (as opposed to it being some reference material where users would search for pieces instead of reading the whole thing).Chuckster555sf wrote:My post is more like 100,000,000. What's the maximum after changing the schema?Marshalrusty wrote:So for single byte characters, that is a maximum of 16,000,000 without changing the schema.Marshalrusty wrote:EDIT: Looks like we use 'mediumtext', which is quite a bit larger at 16 Megabytes.
An average book (250 words per page with 300 pages) has roughly 500,000 characters. 100,000,000,000,000 / 500,000 = 200,000,000, or the Library of Congress 10 times over.
Steve, do you know if I can anchor or have parts of each said chapter jump from chapter to chapter from within the posts, as long as it is still on the same page of the thread? So that way it doesn't have to reload. I'm thinking of doing a table of contents on the first post and then four total chapters with the pages basically being the years (I'm doing a calender from mid 70s to today). And trust me, lots of people will want to see it because it's dedicated to a certain band.Pony99CA wrote:So that's still about 200 books if Rusty's numbers are correct. I'm curious what you would post that is that long and if you actually expect users to read it (as opposed to it being some reference material where users would search for pieces instead of reading the whole thing).Chuckster555sf wrote:My post is more like 100,000,000. What's the maximum after changing the schema?Marshalrusty wrote:So for single byte characters, that is a maximum of 16,000,000 without changing the schema.Marshalrusty wrote:EDIT: Looks like we use 'mediumtext', which is quite a bit larger at 16 Megabytes.
An average book (250 words per page with 300 pages) has roughly 500,000 characters. 100,000,000,000,000 / 500,000 = 200,000,000, or the Library of Congress 10 times over.
One thing to do if you don't want to change the schema is to break the text down into chunks (chapters or even pages) where each chunk gets its own post. That will also make linking to parts of the text much easier.
Steve
If you're sure that the posts will be on the same page, you can use the Goto/Anchor BBCodes. If you're just linking to the start of the post, each post already has an anchor, so you would only need the Goto BBCode (you can find the anchor/post-id by clicking the little icon to the left of the post's author's name).Chuckster555sf wrote:Steve, do you know if I can anchor or have parts of each said chapter jump from chapter to chapter from within the posts, as long as it is still on the same page of the thread? So that way it doesn't have to reload. I'm thinking of doing a table of contents on the first post and then four total chapters with the pages basically being the years (I'm doing a calender from mid 70s to today). And trust me, lots of people will want to see it because it's dedicated to a certain band.