× 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          
 BOOLEAN  IFXBOOLEAN  X  X  X  Stores Boolean values true and false
 DECIMAL  NUMERIC  X  15  5  Stores fixed-point numbers with definable scale and precision 2-21
 FLOAT  NUMERIC  X  X  X  Stores double-precision floating-point numbers corresponding to the double data type in C
 INT  NUMERIC  X  X  X  Stores whole numbers in a range from ?2,147,483,647 to +2,147,483,647 - INT IS ALIAS to INTEGER
 INT8  NUMERIC  X  X  X  
 INTEGER  NUMERIC  X  X  X  Stores whole numbers in a range from ?2,147,483,647 to +2,147,483,647 - INT IS ALIAS to INTEGER
 MONEY  NUMERIC  X  X  X  Stores currency amount
 SERIAL  NUMERIC  X  X  X  SERIAL - Stores sequential integers in same range as INT
 SERIAL8  NUMERIC  X  X  X  Stores large sequential integers in same range as INT8
 SMALLFLOAT  NUMERIC  X  X  X  Stores single-precision floating-point numbers corresponding to the float data type in C 2-43
 SMALLINT  NUMERIC  X  X  X  Stores whole numbers from ?32,767 to +32,767
CHARACTER DATA TYPES          
 CHAR  CHARACTER  25  X  X  Stores character strings; collation is in code-set order - CHARACTER Is a synonym for CHAR
 NCHAR  CHARACTER  25  X  X  Stores character strings; collation is locale dependent
 NVARCHAR  CHARACTER  25  X  X  Stores character strings of varying length (up to 255 bytes); collation is locale dependent
 VARCHAR  CHARACTER  25  X  X  Stores character strings of varying length (up to 255 bytes); collation is in code-set order.
DATE & TIME DATA TYPES        
 DATE  DATE  X  X  X Stores calendar date
 DATETIME  DATETIME  X  X  X Stores calendar date combined with time of day
 INTERVAL  CHARACTER  X  X  X  (Year|Month) Stores a span of time (or level of effort) in units of years and/or months.
  (Day|Fraction) Stores a span of time in a contiguous set of units of days, hours, minutes, seconds, and/or fractions of a second.
BINARY & LARGE OBJECT DATA TYPES          
 BLOB  BINARY  1  X  X  Stores binary data in random-access chunks
 BYTE  BINARY  X  X  X  Stores any kind of binary data, up to 2 ^31 bytes in length
 CLOB  CHARACTER  X  X  X  Stores text data in random-access chunks
 LVARCHAR  CHARACTER  2000  X  X  Stores variable-length data that can exceed 255 bytes
 TEXT  CHARACTER  X  X  X  Stores any kind of text data, up to 2 ^31 bytes in length
Last updated by swissarmyknife(*) on Jun 25, 2009 11:30 PM
This list is empty.

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