How to store MAX data in one field.

sattibabu vatti

Question

Hi ,

I wanted to store max data in one filed.
Is there is any provision to do it in outsystems.

Ex: I wnated to upload 100 pages of document in one field.

Regards,
Sattibabu vatti.

15 Feb 2013

Pedro Cardoso

Hi Sattibabu!

Do you mean you want to enforce some business rule in your datamodel?

If so, this is usually done within an action in OutSystems. We don't normally add contraints in database entities.

Hope it helps

15 Feb 2013

Sagar Nannaware

Hi Pedro,

This reply is on behalf of Sattibabu

Lets say I have one field with string datatype and the situation is we dont know the size of data, so the length could be 1 character or it could be "n" characters.

So, is there any provision to mention length as "MAX" characters as we do in MS SQL.

For ex.
In MS SQL, we can define field length as VARCHAR(MAX), NVARCHAR(MAX)

Hope its clear now.

15 Feb 2013

Pedro Cardoso

Hi Sagar.

When designing an entity, you can set the max of the text attribute. When the platform generates the SQL script, it will be just like you use nvarchar(50), like in the image.

15 Feb 2013

Pedro Cardoso

Sagar,

if you're looking for the maximum size you can store on a column, that depends on the database your using.

If you're using SQL Server, check their documentation on the maximum size allowed by datatype. Example for text.

The text columns are nvarchar if <= 2000 chars, and text of > 2000. See the help online for that.

15 Feb 2013

Sagar Nannaware

Hi Pedro,

Actually, I am using CKEditor widget where I can enter "n" number of characters. Further I want to store this data in the related field which should hold these "n" number of characters.

Is there any solution?

15 Feb 2013

Pedro Cardoso

Ok, I got it.

So, you should point that to a text filed and add a size that can hold a lot of text.

I don't know it there's a way to limit the size of CKEditor's text... or if it inherits the size of the associated textarea... Anyone?

15 Feb 2013

Uddesh Kondekar

We are also having similar requirement. We want to know if we can do something while setting maxlength of entity, which will internally force OutSystems to use nvarchar(max).

As you are aware of nvarchar(max) size is 2GB.

06 Jun 2017

João Batista

Staff

Hello Uddesh,

OS platform generates a nvarchar(max) type field whenever you define an attribute with the type text, and a length >= 2000.

07 Jun 2017

2 replies

Last reply 08 Jun 2017

Show thread

Hide thread

João Batista

Staff

João Batista wrote:

Hello Uddesh,

OS platform generates a nvarchar(max) type field whenever you define an attribute with the type text, and a length >= 2000.

just a quick correction, it needs to be higher than 2000, not equal.

07 Jun 2017

Uddesh Kondekar

João Batista wrote:

Hello Uddesh,

OS platform generates a nvarchar(max) type field whenever you define an attribute with the type text, and a length >= 2000.

just a quick correction, it needs to be higher than 2000, not equal.

Thanks :)

08 Jun 2017

Nathan Hobbs

But would defining it as length 2000 give you unlimited text, (as per nvarchar(max)) or limit it to 2000?

09 Nov 2018

1 reply

16 Nov 2018

Show thread

Hide thread

Douglas

NathanHobbs wrote:

But would defining it as length 2000 give you unlimited text, (as per nvarchar(max)) or limit it to 2000?

It will limit it to 2000, if you don't know how much is the limit or you don't want a limit, you could use a binary data field and transforms it with actions BinaryDataToText and TextToBinaryData.

16 Nov 2018

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines