The BIGINT data type is used to store BIGINTs, which are integers requiring 8 bytes of storage.
[ UNSIGNED ] BIGINT
The BIGINT data type is an exact numeric data type: its accuracy is preserved after arithmetic operations.
A BIGINT value requires 8 bytes of storage.
The range for signed BIGINT values is -263 to 263 - 1, or -9223372036854775808 to 9223372036854775807.
The range for unsigned BIGINT values is 0 to 264 - 1, or 0 to 18446744073709551615.
By default, the data type is signed.
When converting a string to a BIGINT, leading and trailing spaces are removed. If the leading character is '+' it is ignored. If the leading character is '-' the remaining digits are interpreted as a negative number. Leading '0' characters are skipped, and the remaining characters are converted to an integer value. An error is returned if the value is out of the valid range for the destination data type, if the string contains illegal characters, or if the string cannot be decoded as an integer value.
SQL/2003 Vendor extension.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|