INFO: SQL Server CE Query Analyzer Does Not Display Descriptive Data Type (270896)


The information in this article applies to:

  • Microsoft SQL Server 2000 Windows CE Edition
This article was previously published under Q270896

SUMMARY

When you use the Microsoft SQL Server CE Query Analyzer tool to connect to a SQL Server CE database and you run the following query, the data types are represented by numbers instead of by a description: 
SELECT data_type FROM INFORMATION_SCHEMA.COLUMNS

MORE INFORMATION

The Microsoft SQL Server CE Books Online only documents descriptive SQL Server CE data types, not OLEDB data types or codes. You can use the following table to determine the data types:

Numeric ValueOLE DB Data TypeSQL Server CE Data Type
2DBTYPE_I2smallint
3DBTYPE_I4int
4DBTYPE_R4real
5DBTYPE_R8float
6DBTYPE_CYmoney
11DBTYPE_BOOLbit
17DBTYPE_UI1tinyint
20DBTYPE_I8bigint
72DBTYPE_GUIDunique identifier
128DBTYPE_BYTESbinary, image, varbinary
130DBTYPE_WSTRntext, nchar, nvarchar
131DBTYPE_NUMERICnumeric
135DBTYPE_DBTIMESTAMPdatetime
Modification Type:MajorLast Reviewed:11/23/2000
Keywords:kbCodeSnippet kbDSupport kbinfo KB270896
©2002 Microsoft Corporation. All rights reserved.