数値を異�る数値型�列�記録�る

大ã??ã?ªè¨˜æ†¶é ˜åŸŸã‚’å? ã‚?る浮動å°?数点型ã?®å€¤ã‚’ã€?å°?ã?•ã?ªè¨˜æ†¶é ˜åŸŸã?®å ´æ‰€ã?«ä»£å…¥ã?™ã‚‹ã?¨ã??ã€?ã??ã?®å€¤ã?Œå°?ã?•ã?ªè¨˜æ†¶é ˜åŸŸã?®å ´æ‰€ã?«è¨˜éŒ²ã?§ã??ã?ªã?„値ã?§ã?‚れã?°ã‚¨ãƒ©ãƒ¼ã?¨ã?ªã‚Šã?¾ã?™ã€‚ 次ã?«ä¾‹ã‚’示ã?—ã?¾ã?™ã€‚
create table mytable (r REAL, d DOUBLE PRECISION);
0 rows inserted/updated/deleted
INSERT INTO mytable (r, d) values (3.4028236E38, 3.4028235E38);
ERROR X0X41: The number '3.4028236E38' is outside the range for
the data type REAL.
浮動å°?数点型ã?®å€¤ã‚’ã€?INTEGERã?®åˆ—ã?«è¨˜éŒ²ã?§ã??ã?¾ã?™ã€‚å°?数点以下ã?®éƒ¨åˆ†ã?¯åˆ‡ã‚Šæ?¨ã?¦ã‚‰ã‚Œã?¾ã?™ã€‚次ã?«ä¾‹ã‚’示ã?—ã?¾ã?™ã€‚
INSERT INTO mytable(integer_column) values (1.09e0);
1 row inserted/updated/deleted
SELECT integer_column
FROM mytable;
I
---------------
1

æ•´æ•°åž‹ã?«ã?¯ã€?ã??ã?®ç¯„囲内ã?§å°?æ•°ã?®ã?‚る数値を置ã??ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã?Œã€?精度ã?¯å¤±ã‚?れã?¾ã?™ã€‚

å°?æ•°ã?®ã?‚る数値型ã?«ã?¯ã€?ã??ã?®ç²¾åº¦ã?®ç¯„囲内ã?«ã?‚ã‚‹æ•´æ•°ã‚’ç½®ã??ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚例を挙ã?’ã?¾ã?™ã€‚
ij> insert into mytable (decimal_column)
VALUES (55555555556666666666);
ERROR X0Y21: The number '55555555556666666666' is outside the
range of the target DECIMAL/NUMERIC(5,2) datatype.
大ã??ã?ªè¨˜æ†¶é ˜åŸŸã‚’å? ã‚?ã‚‹æ•´æ•°ã?®å€¤ã‚’ã€?å°?ã?•ã?ªè¨˜æ†¶é ˜åŸŸã?«ä»£å…¥ã?™ã‚‹ã?¨ã??ã€?ã??ã?®å€¤ã?Œå°?ã?•ã?ªè¨˜æ†¶é ˜åŸŸã?§ã?¯è¨˜éŒ²ã?§ã??ã?ªã?„ã?¨ã??ã€?エラーã?¨ã?ªã‚Šã?¾ã?™ã€‚以下ã?«ä¾‹ã‚’挙ã?’ã?¾ã?™ã€‚
INSERT INTO mytable (int_column) values 2147483648;
ERROR 22003: The resulting value is outside the range for the 
data type INTEGER.
注: NUMERICã?®å€¤ã?‹ã‚‰å°?数以下をå?–り除ã??å ´å?ˆã€?Derbyã?¯åˆ‡æ?¨ã?¦ã‚’行ã?„ã?¾ã?™ã€‚
関連概念
数値型�概�
関連資料
���行�れる数値型�項目
å°?数を計算ã?™ã‚‹ã?¨ã??ã?®ç›®ç››ã‚Š