Out of range value adjusted for column

proev

decimal(20,10)

jeg tror at det sidste tal skal vaere mindre end det foerste tal

det virker..

men hvordan kan det være det skal være det?

fra docs:

When declaring a DECIMAL or NUMERIC column, the precision and scale can be (and usually is) specified; for example:

salary DECIMAL(5,2)

In this example, 5 is the precision and 2 is the scale. The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point. If the scale is 0, DECIMAL and NUMERIC values contain no decimal point or fractional part.

Standard SQL requires that the salary column be able to store any value with five digits and two decimals. In this case, therefore, the range of values that can be stored in the salary column is from -999.99 to 999.99.

.0123456789 betragtes tilsyneladende ikke som et validt tal

nå på den måde.. :)

lav et svar

svar