SQL Data Types

The following tables summarize the data types that Lyftron supports.

Exact numerics

bigint numeric
bit smallint
decimal smallmoney
int tinyint
money

Approximate Numerics

float real

Date and Time

date datetime2
smalldatetime datetime
time

Character Strings

char varchar
text

Unicode Character Strings

nchar nvarchar
ntext

Binary Strings

binary varbinary
image

Other Data Types

timestamp rowversion
uniqueidentifier sql_variant

Not supported data types

The following table summarizes the data types that Lyftron does not support.

cursor hierarchyid
xml geometry
geography table