Datatypes

The following list describes the SQL Server datatypes. The dbconvert and dbwillconvert functions use these types. In addition, dbcoltype, dbalttype, dbrettype each returns one of these types.

Datatype Description
SQLARRAY 1 byte with variable length
SQLBINARY binary
SQLBIT bit
SQLCHAR char
SQLDATETIM4 4-byte smalldatetime
SQLDATETIME 8-byte datetime
SQLDATETIMN datetime or smalldatetime with null values allowed
SQLDECIMAL decimal
SQLFLT4 4-byte real
SQLFLT8 8-byte float
SQLFLTN float or real with null values allowed
SQLIMAGE image
SQLINT1 1-byte tinyint
SQLINT2 2-byte smallint
SQLINT4 4-byte int
SQLINTN tinyint, smallint, or int with null values allowed
SQLMONEY4 4-byte smallmoney
SQLMONEY 8-byte money
SQLMONEYN money or smallmoney with null values allowed
SQLNUMERIC numeric
SQLTEXT text
SQLVARBINARY varbinary
SQLVARCHAR varchar