Table of articles - Printable Version

Table of articles - Printable Version

+- HelpDeskZ Community (http://community.helpdeskz.com)
+-- Forum: HelpDeskZ 2 (http://community.helpdeskz.com/forum-3.html)
+--- Forum: Support (http://community.helpdeskz.com/forum-5.html)
+--- Thread: Table of articles (/thread-2423.html)

Table of articles - lokirj - 01-10-2023

Hello
What is the text capacity of the table hdz_articles?
I'm asking this because i tried to put an article with thousands of texts and it saves cutting at the end.
Even if you put more text and save, it goes back to the previous cut of the text.
How can i resolve this problem?
Thanks

RE: Table of articles - cord.schneider - 01-12-2023

(01-10-2023, 08:05 PM)lokirj Wrote: Hello
What is the text capacity of the table hdz_articles?
I'm asking this because i tried to put an article with thousands of texts and it saves cutting at the end.
Even if you put more text and save, it goes back to the previous cut of the text.
How can i resolve this problem?
Thanks

hdz_articles stores the content in a TEXT field. According to the MariaDB documentation, a TEXT field can contain a maximum length of 65,535 characters or less if you use multibyte characters. If your content is longer than the maximum size of the field, it will be truncated when you save. You could alter the database to change content to a MEDIUMTEXT (16,777,215 characters) or a LONGTEXT (4,294,967,295 characters), although I'm not sure what the impact will be saving and loading articles that are between 16MB and 4GB in size. Practically, you might want to consider how you can shorten your article or break it into more manageable chunks.

RE: Table of articles - lokirj - 01-12-2023

(01-12-2023, 09:23 AM)cord.schneider Wrote:
(01-10-2023, 08:05 PM)lokirj Wrote: Hello
What is the text capacity of the table hdz_articles?
I'm asking this because i tried to put an article with thousands of texts and it saves cutting at the end.
Even if you put more text and save, it goes back to the previous cut of the text.
How can i resolve this problem?
Thanks
hdz_articles stores the content in a TEXT field. According to the MariaDB documentation, a TEXT field can contain a maximum length of 65,535 characters or less if you use multibyte characters. If your content is longer than the maximum size of the field, it will be truncated when you save. You could alter the database to change content to a MEDIUMTEXT (16,777,215 characters) or a LONGTEXT (4,294,967,295 characters), although I'm not sure what the impact will be saving and loading articles that are between 16MB and 4GB in size. Practically, you might want to consider how you can shorten your article or break it into more manageable chunks.

Hello
I tried the longtext and now its ok Smile

Thanks

RE: Table of articles - cord.schneider - 01-13-2023

(01-12-2023, 11:15 AM)lokirj Wrote: I tried the longtext and now its ok
Thanks

Awesome, glad to hear!