Previous in Contents Next in Contents

Type Property

This property specifies the data type, or an empty string (""), of the column.

Syntax

IColumn.Type

Remarks

The Type property can be an empty string, or one of the values in the following table.

Type Description
VT_I1 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number, for example, 0x3F8.
VT_UI1 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_I2 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_UI2 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_I4 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_UI4 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_I8 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_UI8 Integer. Expressed in either decimal (base 10) or hexadecimal (base 16) notation. The latter requires 0x before the number.
VT_R4 Real number. Can be expressed in scientific notation.
VT_CY Currency. Expressed as two integers, separated by a period, for example, 100.55. Cannot be preceded by $, ¥, £, and so on. This data type does not specify the currency format.
VT_BOOL Boolean. Expressed as TRUE or FALSE.
VT_LPSTR String. Any input accepted.
VT_LPWSTR Unicode string. Any input accepted.
VT_BSTR Basic string. Any input accepted.
VT_CLSID GUID (Globally Unique Identifier). Expressed as xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.
VT_VECTOR Vector properties are fully supported.
VT_DATE Date expressed as an absolute in two forms: yyyy/mm/dd and yyyy/mm/dd hh:mm:ss. Also expressed as a relative date: -#y, -#m, -#w, -#d, -#h, -#n, -#s where the letters correspond to year, month, week, day, hour, minute and second, respectively. Positive relative dates into the future are not supported.
VT_FILETIME Date expressed as an absolute in two forms: yyyy/mm/dd and yyyy/mm/dd hh:mm:ss. Also expressed as a relative date: -#y, -#m, -#w, -#d, -#h, -#n, -#s where the letters correspond to year, month, week, day, hour, minute and second, respectively. Positive relative dates into the future are not supported.

Type is optional. You need not set it to function correctly with any value type returned by a filter. If you don't know the type of a property emitted by the indexing filter, or if the filter or filters for a property do not always emit the same value type, don't set Type. If Type is specified, it must match the value emitted by the filter, otherwise the value is discarded and not indexed.

Example

See Creating_and_Accessing IColumn Interface Objects.

See Also

Length


© 1997-2000 Microsoft Corporation. All rights reserved.