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

Like 0

Like

4 comments

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

Show all comments (3)

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

Like 0

Like

6 comments

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.

Show all comments (5)