Ing Data Types of ole db (SQL Server compact Edition)

SQL Server 2005 compact edition books online Ing Data Types of ole db (SQL Server compact Edition)

 

SQL Server 2005 compact edition converts the ole db data type to the local SQL Server compact edition data type.

Data Type ing

The following table lists the ing from the local data type in SQL Server compact edition to the standard OLE DB data type, including all related attributes and restrictions.

SQL Server compact edition Data Type	Ole db Data Type	Ole db attributes	SQL Server compact Edition
Bigint	Dbtype_i8
Binary	Dbtype_bytes	Dbprop_col_fixedlength = variant_true
Bit	Dbtype_bool
Datetime	Dbtype_dbtimestamp		The valid range of the year is 1753-9999; the valid range of the second is 0-59
Float	Dbtype_r8
Image	Dbtype_bytes
Integer	Dbtype_i4
Money	Dbtype_cy
National Character	Dbtype_wstr	Dbprop_col_fixedlength = variant_true
National Character varying	Dbtype_wstr	Dbprop_col_fixedlength = variant_false
Ntext	Dbtype_wstr
Numeric	Dbtype_numeric
Real	Dbtype_r4
Smallint	Dbtype_i2
Uniqueidentifier	Dbtype_guid
Tinyint	Dbtype_ui1
Varbinary	Dbtype_bytes	Dbprop_col_fixedlength = variant_false