Access Data Types
-
Hi again! I want to move from SQL DB to MS Access but i have problem in converting SQL Data Types to Access Data Type while coding... MS Access program Data Type are: Text Memo Number Date/Time Currency AutoNumber Yes/No OLE Object Hyperlink Attachment What are the related data types From MS Access to OLEDB while coding? .NET Framework Class Library MSDN!: OleDbType Enumeration Member name Description BigInt A 64-bit signed integer (DBTYPE_I8). This maps to Int64. Binary A stream of binary data (DBTYPE_BYTES). This maps to an Array of type Byte. Boolean A Boolean value (DBTYPE_BOOL). This maps to Boolean. BSTR A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to String. Char A character string (DBTYPE_STR). This maps to String. Currency A currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit (DBTYPE_CY). This maps to Decimal. Date Date data, stored as a double (DBTYPE_DATE). The whole portion is the number of days since December 30, 1899, and the fractional portion is a fraction of a day. This maps to DateTime. DBDate Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to DateTime. DBTime Time data in the format hhmmss (DBTYPE_DBTIME). This maps to TimeSpan. DBTimeStamp Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to DateTime. Decimal A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to Decimal. Double A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to Double. Empty No value (DBTYPE_EMPTY). Error A 32-bit error code (DBTYPE_ERROR). This maps to Exception. Filetime A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to DateTime. Guid A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to Guid. IDispatch A pointer to an IDispatch interface (DBTYPE_IDISPATCH). This maps to Object. This data type is not currently supported by ADO.NET. Usage may cause unpredictable results. Integer A 32-bit signed integer (DBTYPE_I4). This maps to Int32. IUnknown A pointer to an IUnknown interface (DBTYPE_UNKNOWN). This maps to O
-
Hi again! I want to move from SQL DB to MS Access but i have problem in converting SQL Data Types to Access Data Type while coding... MS Access program Data Type are: Text Memo Number Date/Time Currency AutoNumber Yes/No OLE Object Hyperlink Attachment What are the related data types From MS Access to OLEDB while coding? .NET Framework Class Library MSDN!: OleDbType Enumeration Member name Description BigInt A 64-bit signed integer (DBTYPE_I8). This maps to Int64. Binary A stream of binary data (DBTYPE_BYTES). This maps to an Array of type Byte. Boolean A Boolean value (DBTYPE_BOOL). This maps to Boolean. BSTR A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to String. Char A character string (DBTYPE_STR). This maps to String. Currency A currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit (DBTYPE_CY). This maps to Decimal. Date Date data, stored as a double (DBTYPE_DATE). The whole portion is the number of days since December 30, 1899, and the fractional portion is a fraction of a day. This maps to DateTime. DBDate Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to DateTime. DBTime Time data in the format hhmmss (DBTYPE_DBTIME). This maps to TimeSpan. DBTimeStamp Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to DateTime. Decimal A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to Decimal. Double A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to Double. Empty No value (DBTYPE_EMPTY). Error A 32-bit error code (DBTYPE_ERROR). This maps to Exception. Filetime A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to DateTime. Guid A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to Guid. IDispatch A pointer to an IDispatch interface (DBTYPE_IDISPATCH). This maps to Object. This data type is not currently supported by ADO.NET. Usage may cause unpredictable results. Integer A 32-bit signed integer (DBTYPE_I4). This maps to Int32. IUnknown A pointer to an IUnknown interface (DBTYPE_UNKNOWN). This maps to O
woff!! :sigh: is there any answer?! :doh: