Prev | Current Page 529 | Next

Kevin Marshall, Chad Pytel, and Jon Yurek

"Pro Active Record: Databases with Ruby and Rails"


SQLite2 does not have a default precision or scale.
??? SQLite3: The valid values for decimal precision in SQLite3 are 1 to 16, and there is no
limit on the values for decimal scale. SQLite3 does not have a default precision or scale.
??? Oracle: The valid values for decimal precision in Oracle are 1 to 38, and the valid values
for decimal scale are -84 to 127. The default scale is 38, and the default precision is 0.
??? DB2: The valid values for decimal precision in DB2 are 1 to 63, and the valid values for
decimal scale are 0 to 62. The default precision is 38, and the default scale is 0.
??? Firebird: The valid values for decimal precision in Firebird are 1 to 18, and the valid values
for decimal scale are 0 to 18. The default scale is 9, and the default precision is 0.
??? FrontBase: The valid values for decimal precision in FrontBase are 1 to 38, and the valid
values for decimal scale are 0 to 38. The default scale is 38, and the default precision is 0.
??? SQL Server: The valid values for decimal precision in SQL Server are 1 to 38, and the
valid values for decimal scale are 0 to 38.


Pages:
517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541