Db

BDP.NET supports the following DB2 type mappings. BDP.NET logical data types for DB2

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

TIMESTAMPDatetime

NA

DateTime

NUMERIC

Decimal

NA

Decimal

DECIMAL Decimal NA

Decimal

BLOB Blob stBinary Byte[]

CLOB Blob stMemo Char[]

Interbase

BDP.NET supports the following Interbase type mappings. BDP.NET logical data types for Interbase

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 OBlob

stBinary

Byte[]

BLOB Sub_Type 1 Blob

stMemo

Char[]

TIMESTAMP

Datetime

NA

DateTime

MS SQL and MSDE_

BDP.NET supports the following MS SQL and MSDE type mappings. BDP.NET logical data types for Oracle

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[]

UNIQUEIDENTIFIERGuid

NA

Guid

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment