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 |