2002faq Posted January 16 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.
teraßyte Posted January 16 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.
opentype Posted January 16 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.
2002faq Posted January 16 Author 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
Jim M Posted January 16 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.
2002faq Posted January 16 Author 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
Jim M Posted January 16 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.
2002faq Posted January 16 Author 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.
Jim M Posted January 16 Posted January 16 Thanks! I've moved this to a ticket so we can further investigate and see what is happening here. 2002faq 1
Recommended Posts