Conversion

Available conversion depends on the Outlook field type and the database field type. In the table below the Microsoft Outlook Types are listed on the horizontal axis and the SQL types on the vertical axis:

 

 

Bool

Long

VarChar

Date

Time

DateTime

Bit

+

+

-

-

-

-

Char

+

+

+

-

-

-

Bigint / Integer

+

+

+

-

-

+2

Tinyint / Smallint

+

+

+

-

-

-

Double / Decimal / Numeric

+

+

+

-

-

-

Real / Float

+

+

+

-

-

-

Varchar

+

+

+

+1

+1

+1

Longvarchar

+

+

+

+1

+1

+1

Timestamp / Type_timestamp / Type_date / Type_time / DateTime

-

-

+1

+

+

+

Binary

-

-

-

-

-

+2

LongVarBinary / Varbinary

-

-

-

-

-

-


+: Conversion possible, it is not mandatory to specify conversion format.

1: The user must specify a format for the conversion.

2: possible if stored as number of seconds elapsed since midnight (00:00:00) January 1, 1970.

 

See also:

Assign table

Conversion - Date and time

Conversion - Bit and Long

Mandatory keys