× 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 -263 and 263 - 1  X  X From -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807)
 UNSIGNED BIGINT  NUMERIC Whole numbers between 0 and 18,446,744,073,709,551,615  X  X  Whole numbers between 0 and 18,446,744,073,709,551,615
 BIT  BIT 0 or 1  X  X  0 or 1
 DECIMAL  NUMERIC 1038 -1 to -1038  15  5  Number 2^38 to -2^38
 DOUBLE PRECISION  NUMERIC  X  X  X  Machine dependant
 Double precision is what comes back from the database for a FLOAT defenition
 FLOAT  NUMERIC  X  X  X  
 INT  NUMERIC -231 and 231 - 1  X  X  Number 2^31 to -2^31 (2mill to - 2mill)
 UNSIGNED INT  NUMERIC Whole numbers between 0 and 4,294,967,295  X  X  Whole numbers between 0 and 4,294,967,295
 MONEY  NUMERIC 922,337,203,685,477.5807 to
-922,337,203,685,477.5808		  X  X  922,337,203,685,477.5807 to -922,337,203,685,477.5808
 NUMERIC  NUMERIC 1038 -1 to -1038  15  5  Number 2^38 to -2^38
 REAL  NUMERIC  X  X  X  Machine dependant
 SMALLINT  NUMERIC -215 and 215 - 1  X  X  Number 2^15 to -2^15 (32,767 to -32,767)
 UNSIGNED SMALLINT  NUMERIC Whole numbers between 0 and 65535  X  x  Whole numbers between 0 and 65535
 SMALLMONEY  NUMERIC 214,748.3647 to -214,748.3648  X  X  214,748.3647 to -214,748.3648
 TINYINT  NUMERIC 0 to 255  X  X  Number 0 - 255
CHARACTER DATA TYPES          
 CHAR  CHARACTER pagesize  X  X  Character 0 to 255
 LONGSYSNAME  CHARACTER  X  X  X  longsysname is defined as: varchar(255) "NOT NULL". You can declare a column, parameter, or variable to be of type longsysname.
 NCHAR  CHARACTER pagesize  X  X  Character 0 to 255
 NVARCHAR  CHARACTER pagesize  X  X  Character 0 to 255
 SYSNAME  CHARACTER  X  X  X  Character 0 to 255
 UNICHAR  CHARACTER pagesize  X  X  Character 0 to 255 -- ? some docs say UNI some N
 UNIVARCHAR  CHARACTER pagesize  X  X  Character 0 to 255 -- ? some docs say UNI some N
 VARCHAR  CHARACTER pagesize  X  X  Character 0 to 255
DATE & TIME DATA TYPES        
 DATE  DATE January 1, 0001 to December 31, 9999  X  X  January 1, 1753 to December 31, 9999
 DATETIME  TIMESTAMP January 1, 1753 to December 31, 9999  X  X  January 1, 1753 to December 31, 9999
 SMALLDATETIME  DATETIME January 1, 1900 to June 6, 2079  X  X  January 1, 1900 to June 6, 2079
 TIME  TIME 12:00:00AM to 11:59:59:999PM  X  X  12:00:00AM to 11:59:59:999PM
 TIMESTAMP  CHARACTER  X  X  X  Every time a row containing a timestamp column is inserted or updated, the timestamp column is automatically updated. A table can have only one column of the timestamp datatype. A column named timestamp will automatically have the system datatype timestamp. Its definition is varbinary(8) NULL.
 BIGTIME  TIME  X  X  X 12:00:00.000000 AM to 11:59:59.999999 PM
 BIGDATETIME  TIMESTAMP  X  X  X January 1, 0001 to December 31, 9999 and 12:00.000000AM to 11:59:59.999999 PM
BINARY & LARGE OBJECT DATA TYPES          
 BINARY  BINARY  1  X  X  Binary 0 - 256 bypes
 IMAGE  BLOB  231 -1 (2,147,483,647) bytes or fewer  X  X  Binary 2 ^31
 TEXT  CHARACTER 231 -1 (2,147,483,647) bytes or fewer  X  X  Characters 2 ^31
 UNITEXT  CHARACTER    X  X  The variable-length unitext datatype can hold up to 1,073,741,823 Unicode characters (2,147,483,646 bytes).
 VARBINARY  BINARY  1  X  X  Binary 0 - 255 bytes
Last updated by ivangron on Feb 22, 2011 3:05 PM
This list is empty.

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