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 |