Conversion Table
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: