SAP IQ

SAP IQ (known also as Sybase IQ or Sybase IQ) is a columnar, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.

SAP IQ bases its performance on columnar data engine, like many competing solutions.

SAP IQ

data types we support

Integral:
bigint
int (integer)
smallint
tinyint
ubigint
uint
usmallint
decimal:
decimal (numeric)
double (double precision)
float (real)
money
smallmoney
text:
char
text
unichar (nchar)
unitext
univarchar (nvarchar)
varchar
Binary:
binary
bit
timestamp
varbinary
Date/Time:
date
datetime (bigdatetime)
smalldatetime
time (bigtime)
Large objects:
image
text
unitext
Other
boolean
timespan