The following list is a representative list of database field types and their underlying field classes.
Microsoft SQL Server Data Type |
Field Class Name |
Integer |
|
bigint |
NumberColumn |
int |
NumberColumn |
smallint |
NumberColumn |
tinyint |
NumberColumn |
Bit |
|
bit |
BooleanColumn |
Decimal - Numeric |
|
decimal |
DecimalColumn |
numeric |
DecimalColumn |
Money |
|
money |
CurrencyColumn |
smallmoney |
CurrencyColumn |
Floating Point |
|
float |
FloatingPointColumn |
real |
FloatingPointColumn |
Date |
|
datetime |
DateColumn |
smalldatetime |
DateColumn |
Character |
|
char |
StringColumn |
varchar |
StringColumn |
text |
VeryLargeStringColumn |
Wide Character |
|
nchar |
StringColumn |
nvarchar |
StringColumn |
ntext |
VeryLargeStringColumn |
Binary |
|
binary |
BinaryColumn |
varbinary |
BinaryColumn |
image |
ImageColumn |
Other |
|
sql_variant |
Not supported |
timestamp |
BinaryColumn |
uniqueidentifier |
UniqueIdentifierColumn |