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-ODBC].

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:
© 2014 Microsoft