REMOTE_DATA_TYPE Return Value

Bits 0–7

ODBC datatype (can be extended for types not defined in ODBC).

Bit 8

1 if nullable, 0 if not nullable.

Bit 9

1 if case-sensitive, 0 if not case-sensitive.

Bits 10, 11

10 (binary); ability to be updated unknown.

Bits 12, 13

Reserved; always returns 00 (binary). The access service bulk-copy feature uses this.

Bits 14, 15

01 (binary); NEWODBCDATATYPE (used for all except REAL) 10 (binary); NEWUSERTYPE (used for REAL).

Numeric types: Bits 17–23 Bits 24–31

Precision. Scale.

Non-numeric types: Bits 16–31

Length.