Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

Mapping Between SQL Types and .NET Types

SQL TYPE

.NET Type

CHAR

String

VARCHAR

String

LVC

String

CLOB

String

NCHAR

String

NVARCHAR

String

CHAR_CS

String

VARCHAR_CS

String

NCHAR_CS

String

NVARCHAR_CS

String

NUMERIC

Nullable<Decimal>

MONEY

Nullable<Decimal>

SMALLINT

Nullable<Int16>

INTEGER

Nullable<Int32>

REAL

Nullable<Single>

FLOAT

Nullable<Double>

DOUBLE PRECISION

Nullable<Double>

DATE

Nullable<DateTime>

TIME

Nullable<TimeSpan>

TIMESTAMP

Nullable<DateTime>

TINYINT

Nullable<Int16>

BINARY

Byte[]

VARBINARY

Byte[]

LVB

Byte[]

BLOB

Byte[]

BIT

Nullable<Boolean>

BIGINT

Nullable<Int64>

TOCIndex