Data types in the index

The default index allows any data type. See the following table for a list of other indexes supported for each data type.

**Table 6-5: Indexes supported for data types**
Data type	Supported indexes	Unsupported indexes
tinyint	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
smallint	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
int	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
unsigned int	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
bigint	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
unsigned bigint	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
numeric, decimal	CMP, HG, HNG, LF	WD, DATE, TIME, DTTM, TEXT
double	LF (HG permitted but not recommended)	CMP, HNG, WD, DATE, TIME, DTTM, TEXT
float	LF (HG permitted but not recommended)	CMP, HNG, WD, DATE, TIME, DTTM, TEXT
real	LF (HG permitted but not recommended)	CMP, HNG, WD, DATE, TIME, DTTM, TEXT
bit	(Default index only)	CMP, HG, HNG, LF, WD, DATE, TIME, DTTM, TEXT
date	CMP, HG, HNG, LF, DATE	WD, TIME, DTTM, TEXT
time	CMP, HG, HNG, LF, TIME	WD, DATE, DTTM, TEXT
datetime, timestamp	CMP, HG, HNG, LF, DTTM	WD, DATE, TIME, TEXT
char <= 255 bytes, character	CMP, HG, HNG, LF, WD, TEXT	DATE, TIME, DTTM
char >255 bytes	CMP, WD, TEXT	HG, HNG,LF, DATE, TIME, DTTM
varchar <= 255 bytes	CMP, HG, HNG, LF, WD, TEXT	DATE, TIME, DTTM
varchar >255 bytes	CMP, WD, TEXT	HG, HNG, LF, DATE, TIME, DTTM
long varchar	WD, TEXT	CMP, HG, HNG, LF, DATE, TIME, DTTM
binary	CMP, HG, LF, TEXT	HNG, WD, DATE, TIME, DTTM
varbinary <= 255 bytes	CMP, HG, LF, TEXT	HNG, WD, DATE, TIME, DTTM
varbinary > 255 bytes	CMP, TEXT	HG, HNG, LF, WD, DATE, TIME, DTTM