Oledbtype and Access Data Types

When you use access
When designing a table, you will see several types of fields that do not match the database data type. This is because these "types" are only display formats and cannot be determined. Access
The Microsoft ole db Provider determines how to set the data format. Jet is not necessarily a public attribute.

Examples of these attributes include:

• Regular date
  ,Long date
  ,Long time
  ,Moderate time
  ,Short Time
  ,Medium date
  , AndShort date
  YesDatetime
  The display format of the data type.
• Hyperlink
  Is a display format of accessText
  Data type.
• True/false
  AndOn/Off
  Both are mapped to accessYes/No
  Data type.

Back to the list of the most common data type mappings at the top

The following table lists Microsoft Access and the data types of these data types and Microsoft. NET Framework.Oledbtype
The most common data type used in enumeration relationships.

Collapse the table
Expand the table

Access type name	Database Data Type	Ole db type	. NET Framework type	Member name
Text	Varwchar	Dbtype_wstr	System. String	Oledbtype. varwchar
Remarks	Longvarwcha R	Dbtype_wstr	System. String	Oledbtype. longvarwchar
Quantity: bytes	Unsignedtinyint	Dbtype_ui1	System. byte	Oledbtype. unsignedtinyint
Yes/No	Boolean	Dbtype_bool	System. Boolean	Oledbtype. Boolean
Date/time	Date and Time	Dbtype_date	System. datetime	Oledbtype. Date
Currency	Decimal	Dbtype_numeric	System. Decimal	Oledbtype. Numeric
Quantity: decimal	Decimal	Dbtype_numeric	System. Decimal	Oledbtype. Numeric
Quantity: double	Double Precision	Dbtype_r8	System. Double	Oledbtype. Double
Automatic ID (synchronous copy ID)	Guid	Dbtype_guid	System. guid	Oledbtype. guid
Number: (synchronous copy ID)	Guid	Dbtype_guid	System. guid	Oledbtype. guid
Automatic number (long integer)	Integer	Dbtype_i4	System. int32	Oledbtype. Integer
Number: (long integer)	Integer	Dbtype_i4	System. int32	Oledbtype. Integer
OLE object	Longvarbinary	Dbtype_bytes	System. byte Array	Oledbtype. longvarbinary
Quantity: single	Single	Dbtype_r4	System. Single	Oledbtype. Single
No.: integer	Smallint	Dbtype_i2	System. int16	Oledbtype. smallint
Binary	Varbinary *	Dbtype_bytes	System. byte Array	Oledbtype. Binary
Hyperlink	Varwchar	Dbtype_wstr	System. String	Oledbtype. varwchar

* This data type access designer is unavailable on the user interface. You must create this data type through code.

 

Address: http://support.microsoft.com/kb/320435