Integer | Community Creatio

19:16 Apr 23, 2021

Hello Community,

There are many use cases where we need to change the data type of a column. We have observed the following behavior wrt data type changes and want to understand why this happens.

DB - MS SQL

Behavior #1

Say a column has been created as String(250) and published. Changing it...MoreLess

4 comments

Roman Rak

17:10 Apr 25, 2021

Hello,

Hope you're doing well.

We tried to reproduce the behavior you have described for different types of DB (PostgreSQL and MSSQL) in two...MoreLess

M Shrikanth

18:34 Apr 25, 2021

Roman Rak,

Hi Roman, Appreciate your effort in trying to reproduce this.

Your steps does look right -

1. Create as 250 in Object designer...MoreLess

Ivanna Yatsura

23:31 Apr 25, 2021

M Shrikanth,

As for your question - no, it was not changed in the latest versions.

Best Regards,

Ivanna Yatsura

M Shrikanth

18:50 May 23, 2021

Roman Rak,

Hi Roman. Checked this use case once again. The behavior I have stated in my question is correct. I have used a on-premises Creatio...MoreLess

Show all comments (3)

Integer

7.15_()

-Studio_Creatio

enterprise_edition_()

Maximum Integer

Janine White

21:01 Jan 30, 2020

How large of an Integer can an Integer field hold? Is it a smallint, int, or bigint?

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver15

6 comments

Oleg Drobina

21:18 Jan 30, 2020

Maximum value integer field can hold is 2147483647 and you can test in on your side as well - the system won't allow you saving numbers greater than 2147483647.

Ryan Farley

21:39 Jan 30, 2020

To add to what Oscar said, the SQL database type is int, but the restriction is also due to the .NET datatype in the entity, which is an Int32...MoreLess

Janine White

21:59 Jan 30, 2020

Add comment

Oscar Dylan, Ryan Farley,

Thanks. I've changed my field to String since the values are out of range.

Julio.Falcon_Nodos

01:37 May 14, 2024

is there any way to accept bigger values? in my case I'm working a project to manage public works, such as roads, dams, stadiums, etc., and the amounts are very large.

Julio.Falcon_Nodos

01:42 May 14, 2024

Also I saw I can introduce larger decimal values, this have no logic why I can introduce 52.437.560.581,00 and not 52.437.560.581? In the case...MoreLess

Yurii Sokil

11:43 Aug 14, 2024

Julio.Falcon_Nodos,

this is .Net Framework restriction and Creatio can't really do anything about it. They could only create a long datatype for big integers

Show all comments (5)

Subscribe to Integer