Show TOC

Background documentationSQL 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