Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Luís Reis
960
Views
6
Comments
Re : Maximum length of the Text Data Type in an Attribute
Question
Hello, everyone.
I'm currently developing an application where i need to save application logs (i created an entity for this). Those logs are in XML, and stored in a Text attribute of that Entity. However, i started wondering: "What is the maximum number of charaters that this attribute can keep?".
This is worrisome, since the XML can potentially be very long, due to various "free text" values it will save.
Thanks in advance.
Evert van der Zalm
MVP
Hello Luis,
Wouldn't it be better to save the XML as a binary data attribute? You can use the TextToBinary data and BinaryToText actions for that (thougt they where in the Text extension).
Kind regards,
Evert
Luís Reis
Hello Evert,
Yes, that is a possible solution actually. I'll probably do that. Thanks.
Still, can anyone still answer the thread title? Even though in this specific case there is an alternative (a good one), i'ts nice to know these things.
Regards,
Luis Reis
Evert van der Zalm
MVP
Hello Luis,
You might want to take a look in this document:
OutSystems Platform - Performance Best Practices (
https://www.outsystems.com/community/download.aspx?DocumentId=202
)
Paragraph 2.1.2 is about 'large' attributes (above 2000 char).
The answer of you question is: What the limit of length of you're database, for sql server see:
maximum attributes length
(in the top of the page you can select you sql server version).
Kind regards,
Evert
Luís Reis
Thank you, Evert.
Regards.
Sea Millo
In answer to the actual question (unlike some people):
As far as I've been able to discover, there is
no note-worthy limit
.
That is, once the specified max length for the text field is above a certain value, the text field will stop being VARCHAR2 and become
CLOB
(Character Large Object) which really doesn't have any length limit at all (
2GB
but really... how would you manage that one?).
Of course, Outsystems probably has a limit that is artifically imposes upon us on-top-of the 2GB limit (sounds like something they would do...).
(Source:
https://www.outsystems.com/help/ServiceStudio/8.0/Using_Data/Database_Data_Types.htm
)
1 reply
22 Jun 2015
Show thread
Hide thread
Kilian Hekhuis
MVP
Sea,
You seem to have a lot of grievances, but this forum is not the right place to vent them. If you want to be helpful, be helpful, and don't start scolding people for not answering the right questions or straw manning OutSystems.
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
Loading...