Column Name: Supported Physical Column Types

The following table lists the physical column types that can be configured for CIAI queries.

Physical Type
Database Value	Maps To	Can Be Configured for CIAI Queries?
C	Char	Yes
D	Date	No
N	Number	No
S	Time Stamp	No
T	Date Time	No
U	UTC Date Time	No
V	Varchar	Yes
X	Text	Yes
L	CLOB	Yes

Text and CLOB are accepted by the Case Insensitivity Wizard as valid. However, the wizard does not create a CIAI column or CIAI indexes for these two types. The wizard sets Default Insensitivity to DB Case & Accent.