Data Types

The following list describes Microsoft® SQL Server™ 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

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.