Data Types
Data Type | SQL Server (SQLOLEDB; SQLNCLI10) | SQL Server (SqlClient) | Jet | Oracle (OracleClient) | DB2 (DB2OLEDB) | DB2 (IBMDADB2) |
---|---|---|---|---|---|---|
DT_BOOL | bit | bit | Bit | |||
DT_BYTES | binary, varbinary, timestamp | binary, varbinary, timestamp | BigBinary, VarBinary | RAW | ||
DT_CY | smallmoney, money | smallmoney, money | Currency | |||
DT_DATE | ||||||
DT_DBDATE | date (Transact-SQL) | date (Transact-SQL) | date | date | date | |
DT_DBTIME | timestamp | time | time | |||
DT_DBTIME2 | time (Transact-SQL)(p) | time (Transact-SQL) (p) | ||||
DT_DBTIMESTAMP | datetime (Transact-SQL), smalldatetime (Transact-SQL) | datetime (Transact-SQL), smalldatetime (Transact-SQL) | DateTime | TIMESTAMP, DATE, INTERVAL | TIME, TIMESTAMP, DATE | TIME, TIMESTAMP, DATE |
DT_DBTIMESTAMP2 | datetime2 (Transact-SQL) | datetime2 (Transact-SQL) | timestamp | timestamp | timestamp | |
DT_DBTIMESTAMPOFFSET | datetimeoffset (Transact-SQL)(p) | datetimeoffset (Transact-SQL)(p) | timestampoffset | timestamp, varchar | timestamp, varchar | |
DT_DECIMAL | ||||||
DT_FILETIME | ||||||
DT_GUID | uniqueidentifier | uniqueidentifier | GUID | |||
DT_I1 | ||||||
DT_I2 | smallint | smallint | Short | SMALLINT | SMALLINT | |
DT_I4 | int | int | Long | INTEGER | INTEGER | |
DT_I8 | bigint | bigint | BIGINT | BIGINT | ||
DT_NUMERIC | decimal, numeric | decimal, numeric | Decimal | NUMBER, INT | DECIMAL, NUMERIC | DECIMAL, NUMERIC |
DT_R4 | real | real | Single | REAL | REAL | |
DT_R8 | float | float | Double | FLOAT, REAL | FLOAT, DOUBLE | FLOAT, DOUBLE |
DT_STR | char, varchar | VarChar | CHAR, VARCHAR | CHAR, VARCHAR | ||
DT_UI1 | tinyint | tinyint | Byte | |||
DT_UI2 | ||||||
DT_UI4 | ||||||
DT_UI8 | ||||||
DT_WSTR | nchar, nvarchar, sql_variant, xml | char, varchar, nchar, nvarchar, sql_variant, xml | LongText | CHAR, ROWID, VARCHAR2, NVARCHAR2, NCHAR | GRAPHIC, VARGRAPHIC | GRAPHIC, VARGRAPHIC |
DT_IMAGE | image | image | LongBinary | LONG RAW, BLOB, LOBLOCATOR, BFILE, VARGRAPHIC, LONG VARGRAPHIC, user-defined | CHAR () FOR BIT DATA, VARCHAR () FOR BIT DATA | CHAR () FOR BIT DATA, VARCHAR () FOR BIT DATA, BLOB |
DT_NTEXT | ntext | text, ntext | LONG, CLOB, NCLOB, NVARCHAR, TEXT | LONG VARCHAR, NCHAR, NVARCHAR, TEXT | LONG VARCHAR, DBCLOB, NCHAR, NVARCHAR, TEXT | |
DT_TEXT | text |
Comments
Post a Comment