2002faq Posted January 16 Share Posted January 16 Is there a Database Record Size limit? I am creating an article on our site that is longer than most that we have done in the past, but it is getting truncated every time I save in a specific spot. Is this intentional or a bug? Thank you, Steve K. Link to comment Share on other sites More sharing options...
teraßyte Posted January 16 Share Posted January 16 The content field for custom databases in Pages is a MEDIUMTEXT column, so it can hold ~16,7 million characters. The character count includes also the HTML tags you can't see while using the editor: bold format, italic, font size, colors, etc. I believe older versions used TEXT until a certain point, though. If that is your case, a TEXT column can hold only 65k characters. Link to comment Share on other sites More sharing options...
opentype Posted January 16 Share Posted January 16 5 hours ago, 2002faq said: Is there a Database Record Size limit? Yes, every field type has a reserved size. So, not a bug. Link to comment Share on other sites More sharing options...
2002faq Posted January 16 Author Share Posted January 16 13 hours ago, teraßyte said: The content field for custom databases in Pages is a MEDIUMTEXT column, so it can hold ~16,7 million characters. The character count includes also the HTML tags you can't see while using the editor: bold format, italic, font size, colors, etc. I believe older versions used TEXT until a certain point, though. If that is your case, a TEXT column can hold only 65k characters. how does one find out what it is set to on their DB? I am on the cloud service with Invision. Thank you, Steve Link to comment Share on other sites More sharing options...
Jim M Posted January 16 Share Posted January 16 Do you have an example of what you're attempting to post? I think it would be rather hard to hit a limit there but there may be something else going on. Link to comment Share on other sites More sharing options...
2002faq Posted January 16 Author Share Posted January 16 The article is not published yet, so it is not publicly available, here is a link, if you wish to see it from the Administrator side https://www.bmw2002faq.com/articles/technical-articles/history-and-reference/bmw-02-series-rear-panel-badging-r467/ Or should I file a support ticket? steve Link to comment Share on other sites More sharing options...
Jim M Posted January 16 Share Posted January 16 So the article body there is just over 67k characters. The article is quite large but nothing which the dataset can't handle so far. What is the total size of the article which you are attempting to add? How many more images are you attempting to add? You may hit some restriction on our firewall prior to hitting the size allotment for the database. Link to comment Share on other sites More sharing options...
2002faq Posted January 16 Author Share Posted January 16 I think it will increase by about 30% to 40% As it stands, it gets truncated as soon as I add more to the last paragraph. Link to comment Share on other sites More sharing options...
Jim M Posted January 16 Share Posted January 16 Are you OK with us adding to the article? Link to comment Share on other sites More sharing options...
2002faq Posted January 16 Author Share Posted January 16 Yes, that is fine. Link to comment Share on other sites More sharing options...
Jim M Posted January 16 Share Posted January 16 Thanks! I've moved this to a ticket so we can further investigate and see what is happening here. 2002faq 1 Link to comment Share on other sites More sharing options...
Recommended Posts