RAD Studio for Microsoft .NET
|
AdoDbx Client data types map to .NET logical types. Dependant upon the database, AdoDbx Client data types map to native data types. Where applicable, AdoDbx Client provides:
The DataSet class within ADO.NET uses .NET Framework data types. AdoDbx Client data types logically map .NET data types for supported databases. During designtime, you can use AdoDbx Client logical types, which will map to the appropriate native type.
The .NET Framework includes a wide range of logical data types. AdoDbx Client inherits logical data types, providing built-in mappings to supported databases. AdoDbx Client supports logical data type mappings for DB2, InterBase, MS SQL, MSDE, and Oracle.
AdoDbx Client supports the following DB2 type mappings.
DB2 Type |
Bdp Type |
BdpSubType |
System.Type |
CHAR |
String |
stFixed |
String |
VARCHAR |
String |
NA |
String |
SMALLINT |
Int16 |
NA |
Int16 |
BIGINT |
Int64 |
NA |
Int64 |
INTEGER |
Int32 |
NA |
Int32 |
DOUBLE |
Double |
NA |
Double |
FLOAT |
Float |
NA |
Single |
REAL |
Float |
NA |
Single |
DATE |
Date |
NA |
DateTime |
TIME |
Time |
NA |
DateTime |
TIMESTAMP |
Datetime |
NA |
DateTime |
NUMERIC |
Decimal |
NA |
Decimal |
DECIMAL |
Decimal |
NA |
Decimal |
BLOB |
Blob |
stBinary |
Byte[] |
CLOB |
Blob |
stMemo |
Char[] |
AdoDbx Client supports the following InterBase type mappings.
InterBase Type |
Bdp Type |
BdpSubType |
System.Type |
CHAR |
String |
stFixed |
String |
VARCHAR |
String |
NA |
String |
SMALLINT |
Int16 |
NA |
Int16 |
INTEGER |
Int32 |
NA |
Int32 |
FLOAT |
Float |
NA |
Single |
DOUBLE |
Double |
NA |
Double |
BLOB Sub_Type 0 |
Blob |
stBinary |
Byte[] |
BLOB Sub_Type 1 |
Blob |
stMemo |
Char[] |
TIMESTAMP |
Datetime |
NA |
DateTime |
AdoDbx Client supports the following MS SQL and MSDE type mappings.
MSSQL Type |
Bdp Type |
BdpSubType |
System.Type |
BIGINT |
Int64 |
NA |
Int64 |
INT |
Int32 |
NA |
Int32 |
SMALLINT |
Int16 |
NA |
Int16 |
TINYINT |
Int16 |
NA |
Int16 |
BIT |
Boolean |
NA |
Boolean |
DECIMAL |
Decimal |
NA |
Decimal |
NUMERIC |
Decimal |
NA |
Decimal |
MONEY |
Decimal |
NA |
Decimal |
SMALLMONEY |
Decimal |
NA |
Decimal |
FLOAT |
Double |
NA |
Double |
REAL |
Float |
NA |
Single |
DATETIME |
DateTime |
NA |
DateTime |
SMALLDATETIME |
DateTime |
NA |
DateTime |
CHAR |
String |
stFixed |
String |
VARCHAR |
String |
NA |
String |
TEXT |
Blob |
stMemo |
Char[] |
BINARY |
VarBytes |
NA |
Byte[] |
VARBINARY |
VarBytes |
NA |
Byte[] |
IMAGE |
Blob |
stBinary |
Byte[] |
TIMESTAMP |
VarBytes |
NA |
Byte[] |
UNIQUEIDENTIFIER |
Guid |
NA |
Guid |
AdoDbx Client supports the following Oracle type mappings.
Oracle Type |
Bdp Type |
BdpSubType |
System.Type |
CHAR |
String |
stFixed |
String |
NCHAR |
String |
stFixed |
String |
VARCHAR |
String |
NA |
String |
NVARCHAR |
String |
NA |
String |
VARCHAR2 |
String |
NA |
String |
NVARCHAR2 |
String |
NA |
String |
NUMBER |
Decimal |
NA |
Decimal |
DATE |
Date |
NA |
DateTime |
BLOB |
Blob |
stHBinary |
Byte[] |
CLOB |
Blob |
stHMemo |
Char[] |
LONG |
Blob |
stMemo |
Char[] |
LONG RAW |
Blob |
stBinary |
Byte[] |
BFILE |
Blob |
stBFile |
Char[] |
ROWID |
String |
NA |
String |
AdoDbx Client supports the following Sybase type mappings.
Sybase Type |
Bdp Type |
BdpSubType |
System.Type |
CHAR |
String |
stFixed |
String |
VARCHAR |
String |
NA |
String |
INT |
Int32 |
NA |
Int32 |
SMALLINT |
Int16 |
NA |
Int16 |
TINYINT |
Int16 |
NA |
Int16 |
DOUBLE PRECISION |
Float |
NA |
Single |
FLOAT |
Float |
NA |
Single |
REAL |
Float |
NA |
Single |
NUMERIC |
Decimal |
NA |
Decimal |
DECIMAL |
Decimal |
NA |
Decimal |
SMALLMONEY |
Decimal |
NA |
Decimal |
MONEY |
Decimal |
NA |
Decimal |
SMALLDATETIME |
DateTime |
NA |
DateTime |
DATETIME |
DateTime |
NA |
DateTime |
IMAGE |
Blob |
stBinary |
Byte[] |
TEXT |
Blob |
stMemo |
Char[] |
BIT |
Boolean |
NA |
Boolean |
TIMESTAMP |
VarBytes |
NA |
Byte[] |
BINARY |
Bytes |
NA |
Byte[] |
VARBINARY |
VarBytes |
NA |
Byte[] |
SYSNAME |
String |
NA |
String |
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
|
What do you think about this topic? Send feedback!
|