× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

Data Types

Data Type Name Raw Type Length (Range)
 Precision
(Range)		 Scale
(Range)		 Description
NUMERIC DATA TYPES          
 BIGINT  NUMERIC

Signed values is –263 to 263 – 1, or –9223372036854775808 to 9223372036854775807

Unsigned values is 0 to 264 – 1, or 0
to 18446744073709551615

  X  X REAL - The range of values is 1.175495e-38 to 3.402823e+38. Values held as REAL are accurate to 10 significant digits, but may be subject to round-off error beyond the sixth digit.
The range for signed BIGINT values is 2 63 to 2 63 1, or 9223372036854775808 to 9223372036854775807.
The range for unsigned BIGINT values is 0 to 2 64 1, or 0 to 18446744073709551615.
 BIT  BIT 0 and 1  X  X for Boolean values - By default, columns of BIT data type do not allow NULL.
 DECIMAL  NUMERIC  X  15  5 The DECIMAL data type is an exact numeric data type; its accuracy is preserved to the least significant digit after arithmetic operations.
 DOUBLE  NUMERIC 2.22507385850721e–308 to 1.79769313486231e+308  X  X The value range is 2.22507385850721308 to 1.79769313486231e+308.
 FLOAT  NUMERIC  X  X  X When a column is created using the FLOAT ( precision ) data type, columns on all platforms are guaranteed to hold the values to at least the specified minimum precision. In contrast, REAL and DOUBLE do not guarantee a platform-independent minimum precision.
 INT  NUMERIC Signed integers is –231 to 231 – 1, or –2147483648 to 2147483647
Unsigned integers is 0 to 232 – 1, or 0 to 4294967295		  X  X
 INTEGER  NUMERIC Signed integers is –231 to 231 – 1, or –2147483648 to 2147483647
Unsigned integers is 0 to 232 – 1, or 0 to 4294967295		  X  X  The range for signed integers is 31 to 2 31 1, or 2147483648 to 2147483647.
 The range for unsigned integers is 0 to 2 32 1, or 0 to 4294967295.
 MONEY  NUMERIC  X  X  X  The MONEY data type is implemented as a domain, as NUMERIC(19,4), allowing NULL.
 NUMERIC  NUMERIC  X  15  5  The NUMERIC data type is an exact numeric data type; its accuracy is preserved to the least significant digit after arithmetic operations.
 SMALLINT  NUMERIC Signed smallint –215 to 215 – 1, or –32768
to 32767
Unsigned SMALLINT values is 0 to 216 – 1, or 0 to 65535		  X  X  The range for signed SMALLINT values is 2 15 to 2 15 1, or 32768 to 32767.
 The range for unsigned SMALLINT values is 0 to 2 16 1, or 0 to 65535.
 SMALLMONEY  NUMERIC -214 748.3648 to 214 748.3647  X  X  The SMALLMONEY data type is implemented in Adaptive Server Anywhere as a domain, as NUMERIC(10,4), allowing NULL.
 TINYINT  NUMERIC  0 to 28 – 1, or 0 to 255.  X  X  The range for TINYINT values is 0 to 2 8 1, or 0 to 255.
 UNIQUEIDENTIFIER  CHARACTER  X  X  X
 UNIQUEIDENTIFIERSTR    X  X  X  Stores UUID (also known as GUID) values
CHARACTER DATA TYPES          
 CHAR  CHARACTER  up to 254  X  X  For strings up to 254 bytes in length
 VARCHAR  CHARACTER  up to 254  X  X  For strings up to 254 bytes in length,
 SYSNAME  CHARACTER  X  X  X  
DATE 7 TIME DATA TYPES        
 DATE  DATETIME  X  X  X  A calendar date, such as a year, month and day. - Including Hours and Minutes
 DATETIME  TIMESTAMP  X  X  X  A domain, implemented as TIMESTAMP. - Backward compat to ASE
 SMALLDATETIME  DATETIME  X  X  X  A domain, implemented as TIMESTAMP. - Backward compat to ASE
 TIME  TIME  X  X  X  The time of day, containing hour, minute, second and fraction of a second.
 TIMESTAMP  TIMESTAMP 1600-02-28 23:59:59 to 7911-01-01
00:00:00		  X  X  The point in time, containing year, month, day, hour, minute, second and fraction of a second.
BINARY AND LONG OBJECT DATA TYPES          
 BINARY  BINARY  1  X  X  Binary data - The maximum size allowed is 32767.
 IMAGE  BLOB  X  X  X  LONG BINARY data allowing NULL.
 LONG BINARY  BINARY  X  X  X  LONG BINARY - Long Binary - The maximum size is limited by the maximum size of the database file.
Arbitrary length strings. The maximum size is limited by the maximum size of the database file (currently 2 Gb).
 LONGVARCHAR  CHARACTER  25  X  X  LONG BINARY - Long Binary - The maximum size is limited by the maximum size of the database file.
Arbitrary length strings. The maximum size is limited by the maximum size of the database file (currently 2 Gb).
 TEXT  CHARACTER  X  X  X  This is a domain. It is implemented as a LONG VARCHAR allowing NULL.
 VARBINARY  BINARY  1  X  X  Identical to BINARY.
Last updated by swissarmyknife(*) on Sep 23, 2009 10:58 PM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017