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 |