Skip to Content (Press Enter)
2020-09-15 09-38-17
Jessica Marques
293Views
10Comments
Solved
data longer than 2 thousand characters wil be text or binary?
Question
Best Practices

I have doubts regarding data longer than 2 thousand characters in the service studio, will they then be of text or binary type in the SQL server/database? This doubt arises because of these two excerpts highlighted in the text of the link below:

https://success.outsystems.com/documentation/best_practices/performance_and_monitoring/performance_best_practices_data_model/


1
0
16 Dec 2023
Copy Link
2023-12-16 19-57-03
Sanjay Kushwah
Solution

Hi @Jessica Marques,

In above image here is clearly mentioned on which database if length if less than 2000 characters than what will be datatype in data base and when length is more than 2000 characters what will be datatype in different-2 kind of databases.

Check out my answer on this post  if you are confused when we need seprate entity or when not for stroing binary or text (more than 2000 characters).

https://www.outsystems.com/forums/discussion/93306/why-is-this-answer-correct-in-data-model/


Kind regards,

Sanjay Kushwah

See solution in context
3
0
17 Dec 2023
Copy Link
2020-09-15 09-38-17
Jessica Marques

Hi @Sanjay Kushwah 

Thanks for the answer. Please let me know where I can find this image in the outsystems documentation. Could you share the link?

Best Regards, 

Jessica Marques. 

0
0
17 Dec 2023
Copy Link
2020-09-15 09-38-17
Jessica Marques

Replying to Alexandre Yip's comment on 18 Dec 2023 00:27:43

Hi @Alexandre Yip  thanks for share. 

I'm just curious why this table (for this link) doesn't show MySQL as an image shared by @Sanjay Kushwah 


0
0
18 Dec 2023
Copy Link
2020-09-15 09-38-17
Jessica Marques

Hi @Prince Aadil Khan Panwar 

Actually I'm more confused, because, for example in this post, they say that when it is more than 2000 it will be nvarchar? So now I would like to know if it will be binary, text or Nvarchar?

And how can I see this in practice?

https://www.outsystems.com/forums/discussion/39802/maximum-size-for-text-data-type/ 

thanks, 

Jessica. 


0
0
16 Dec 2023
Copy Link
2023-12-16 19-57-03
Sanjay Kushwah
Solution

Hi @Jessica Marques,

In above image here is clearly mentioned on which database if length if less than 2000 characters than what will be datatype in data base and when length is more than 2000 characters what will be datatype in different-2 kind of databases.

Check out my answer on this post  if you are confused when we need seprate entity or when not for stroing binary or text (more than 2000 characters).

https://www.outsystems.com/forums/discussion/93306/why-is-this-answer-correct-in-data-model/


Kind regards,

Sanjay Kushwah

3
0
17 Dec 2023
Copy Link
2020-09-15 09-38-17
Jessica Marques

Hi @Sanjay Kushwah 

Thanks for the answer. Please let me know where I can find this image in the outsystems documentation. Could you share the link?

Best Regards, 

Jessica Marques. 

0
0
17 Dec 2023
Copy Link
2020-09-15 09-38-17
Jessica Marques

Replying to Alexandre Yip's comment on 18 Dec 2023 00:27:43

Hi @Alexandre Yip  thanks for share. 

I'm just curious why this table (for this link) doesn't show MySQL as an image shared by @Sanjay Kushwah 


0
0
18 Dec 2023
Copy Link
2024-02-16 07-43-18
Amit Verma

Hi @Jessica Marques,

As per OS standard - Outsystems Best Practices 

Isolate large text and binary data

Avoid the use of 2000+ characters in a text field; data fields greater than 2000 bytes are converted into a Text data type which in turn are much slower to process and decrease performance overall. As a rule, isolate binary and/or large text fields in separate entities and only retrieve them when they are strictly necessary.

Performance Top 10 Rules - OutSystems Best Practices 

Thanks,

Amit

3
0
17 Dec 2023
Copy Link
2020-09-15 09-38-17
Jessica Marques

Hi @Amit Verma  

It was in this documentation that my doubt arose, because first the text, as you mentioned, says that it will be text, but then it states that it will be binary.

Best Regards, 

Jessica Marques. 

0
0
17 Dec 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.