Sql database column type decimal

[Adem]

Hello,

I want to use three digit money input after the dot
type of column: DECIMAL, 6,3
Sample:
0.000
but after 999.000 the database gives an error
What am I supposed to do with the length of this? “DECIMAL, 6.3”

[Strider64]

Wouldn’t DECIMAL, 7, 3 work or something like that?

[skawid]

The decimal column type has a strictly defined size for performance reasons. If you know the largest number you’re going to be storing, just define the column with that length. You can go up to DECIMAL(65, 3).

[Adem]

@Strider64

Wouldn’t DECIMAL, 7, 3 work or something like that?

Yes, it works, I understood the logic later I set it to 19.3 thank you

[Adem]

@skawid

The decimal column type has a strictly defined size for performance reasons. If you know the largest number you’re going to be storing, just define the column with that length. You can go up to DECIMAL(65, 3).

Now I understand the logic better
Thank you so much