Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.5.190 ODBCType

Office

The ODBCType structure specifies an ODBC data type identifier.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

wTypeSql

wTypeSql (2 bytes): A signed integer that specifies an ODBC data type. The following are example data types supported by ODBC. For more information about ODBC, see [MSDN-OpenDBConnectivity].

Value

SQL Type

Data Type

0x0000

SQL_TYPE_NULL

Undetermined type, data source (1) does not support typed data. Data type determined based on data content: date and time, decimal or text.

0x0001

SQL_CHAR

Fixed-length string of ANSI characters

0x0003

SQL_DECIMAL

Fixed-precision, Fixed-scale numbers

0x0004

SQL_INTEGER

32-bit signed integer

0x0005

SQL_SMALLINT

16-bit signed integer

0x0006

SQL_FLOAT

User-specified precision floating-point

0x0007

SQL_REAL

7-digits precision floating-point

0x0008

SQL_DOUBLE

15-digits precision floating-point

0x000B

SQL_TIMESTAMP

Date and Time

0x000C

SQL_VARCHAR

Variable-length string of ANSI characters

0xFFF9

SQL_BIT

Bit (1 or 0)

0xFFFE

SQL_BINARY

Fixed-length binary data

Show:
© 2015 Microsoft