The following list describes Microsoft® SQL Server™ 2000 data types. The dbconvert and dbwillconvert functions use these types. In addition, dbcoltype, dbalttype, dbrettype each returns one of these types.
| Data type | 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 |