Import Code | CONNX Data Type | SQL Data Type | SQL Length | VMS Equivalent Data Types | Description |
444 | Adabas Text (LA VarChar) | Varchar | -1 | ||
445 | Adabas Text (L4 VarChar) | Varchar | -1 | ||
446 | Unicode Char (UTF-8) | Unicode | -2 | ||
447 | Unicode Char (UTF-8) | VarUnicode | -2 | ||
448 | Unicode LA VarChar (UTF-8) | VarUnicode | -2 | ||
449 | Unicode L4 VarChar (UTF-8) | VarUnicode | -2 | ||
450 | ODBC Bit (not used) | Bit | 1 | ||
451 | ODBC Tiny Integer (not used) | TinyInt | 1 | ||
452 | ODBC Date | Date | 6 | ||
453 | ODBC Time | Time | 6 | ||
454 | ODBC Timestamp | Timestamp | 16 | ||
455 | Maestro Date (DD/MM/YYYY) | Date | 6 | ||
456 | PRO IV Text Integer -> Date | Date | 6 | ||
457 | TextDBMS Variable Text | VarChar | -1 | ||
458 | VMS Time with Precision | VarChar | 18 | ||
459 | OLEDB Variable Length WSTR | VarUnicode | -1 | ||
460 | Unicode CLOB | VarUnicode | -1 | ||
461 | OLEDB WSTR (BE) | Unicode | -1 | ||
462 | OLEDB Variable Length WSTR(BE) | VarUnicode | -1 | ||
463 | Unicode CLOB (BE) | VarUnicode | -1 | ||
464 | ODBC Char | Char | -1 | ||
465 | Adabas Natural Date [Iterative] | Date | 6 | ||
466 | ZZ [deprecated] Adabas Natural Date Unpacked [Iterative] | Date | 6 | ||
467 | ZZ [deprecated] Adabas Natural Timestamp Unpacked [Iterative] | Timestamp | 16 | ||
468 | Adabas Natural Timestamp [Iterative] | Timestamp | 16 | ||
469 | Adabas Natural Timestamp -> Date [Iterative] | Date | 6 | ||
470 | Text seconds since midnight (SSSSS) | Time | 6 | ||
471 | PACKED Decimal 3.5 -> double | Double | 8 | ||
472 | CONNXStore TID | VarChar | 18 | ||
473 | CONNXStore TID (BE) | VarChar | 18 | ||
474 | ODBC Small Integer | SmallInt | 2 | ||
475 | ODBC Unsigned Small Integer | SmallInt | 2 | ||
476 | ODBC Integer | Integer | 4 | ||
477 | ODBC Unsigned Integer | Integer | 4 | ||
478 | ODBC Big Integer | Bigint | 8 | ||
479 | ODBC Unsigned Big Integer | Bigint | 8 | ||
480 | ODBC Real | Double | 8 | ||
481 | ODBC Double | Double | 8 | ||
482 | Quadword (BE) | Bigint | 4 | ||
483 | Quadword (BE) Unsigned | Bigint | 4 | ||
484 | Quadword | Bigint | 4 | ||
485 | FHP Julian Day Integer | Date | 6 | ||
486 | FHP Julian Day String | Date | 6 | ||
487 | APCO Small Date (3 bytes) | Date | 6 | ||
488 | APCO Hex Nybbles | Integer | 4 | ||
489 | APCO Small Date (4 bytes) | Date | 6 | ||
490 | APCO 4C Date | Date | 6 | ||
491 | Word Big Endian Date | Date | 6 | ||
492 | DB2 Bigint | Bigint | 4 | ||
493 | DB2 Bigint Big Endian | Bigint | 4 |