× 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
          
 BIT  BIT  0 or 1  X  X  0 or 1
 DECIMAL  NUMERIC -1038 to 1038 -1  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 (-2,147,483,648) to
231 -1 (2,147,483,647)		  X  X  Number 2^31 to -2^31 (2mill to - 2mill)
 MONEY  NUMERIC -922,337,203,685,477.5808 to
922,337,203,685,477.5807		  X  X  922,337,203,685,477.5807 to -922,337,203,685,477.5808
 NUMERIC  NUMERIC  -1038 to 1038 -1  15  5  Number 2^38 to -2^38
 REAL  NUMERIC  X  X  X  Machine dependant
 SMALLINT  NUMERIC -215 (-32,768) to 215 -1 (32,767)  X  X  Number 2^15 to -2^15 (32,767 to -32,767)
 SMALLMONEY  NUMERIC -214,748.3648 to 214,748.3647  X  X  214,748.3647 to -214,748.3648
 TINYINT  NUMERIC 0 to 255  X  X  Number 0 - 255
CHARACTER DATA TYPES          
 CHAR  CHARACTER 255 characters or fewer  X  X  Character 0 to 255
 NCHAR  CHARACTER 255 characters or fewer  X  X  Character 0 to 255
 NVARCHAR  CHARACTER 255 characters or fewer  X  X  Character 0 to 255
 SYSNAME  CHARACTER  X  X  X  Character 0 to 255
 VARCHAR  CHARACTER 255 characters or fewer  X  X  Character 0 to 255
DATE & TIME DATA TYPES        
 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
 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.
BINARY & LARGE OBJECT DATA TYPES          
 BINARY  BINARY 255 characters or fewer  X  X  Binary 0 - 256 bypes
 IMAGE  BLOB 231 -1 (2,147,483,647) bytes  X  X  Binary 2 ^31
 TEXT  CHARACTER 231 -1 (2,147,483,647) bytes  X  X  Characters 2 ^31
 VARBINARY  BINARY 255 characters or fewer  X  X  Binary 0 - 255 bytes
Last updated by swissarmyknife(*) on Jun 24, 2009 8:12 PM
This list is empty.

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