SQL Data Types for Columns
The following table lists values for the SQLDataType
attribute of the Columns
node. For more information, see XML Connector.
Data Type |
SQLDataType Value |
Bit (Boolean) |
-7 |
Tiny Integer |
-6 |
Big Integer |
-5 |
Long Variable Binary |
-4 |
Variable Binary |
-3 |
Binary |
-2 |
Long Variable Character (String) |
-1 |
Null |
0 |
Character (String) |
1 |
Numeric |
2 |
Decimal |
3 |
Long Integer |
4 |
Short Integer |
5 |
Float |
6 |
Real |
7 |
Double |
8 |
Variable Character |
12 |
Date |
91 |
Time |
92 |
Date and time (TimeStamp) |
93 |