SQL Data Types
The following tables summarize the data types that Lyftrondata supports.
Exact numerics
Name | Value |
---|---|
bigint | numeric |
bit | smallint |
decimal | smallmoney |
int | tinyint |
money |
Approximate Numerics
Name | Value |
---|---|
float | real |
Date and Time
Name | Value |
---|---|
date | datetime2 |
smalldatetime | datetime |
time |
Character Strings
Name | Value |
---|---|
char | varchar |
text |
Unicode Character Strings
Name | Value |
---|---|
nchar | nvarchar |
ntext |
Binary Strings
Name | Value |
---|---|
binary | varbinary |
image |
Other Data Types
Name | Value |
---|---|
timestamp | rowversion |
uniqueidentifier | sql_variant |
Not supported data types
The following table summarizes the data types that Lyftrondata does not support.
Name | Value |
---|---|
cursor | hierarchyid |
xml | geometry |
geography | table |