This document is archived and information here might be outdated. Recommended version. |
Indicates the type of column used in a data definition.
Constant | Value | Description |
---|---|---|
colINTEGER | 1 | Integer column type. |
colDOUBLE | 2 | Double column type. |
colDATE | 3 | OLE date column type. |
colTIMESTAMP | 4 | Time value column type. Value can be internal datetime format or string. |
colSTRING | 5 | String column type with unlimited characters. Databases convert this to memo or blob columns. |
colSTRING64 | 6 | String column type with only 64 characters. This is needed for databases to allow queries on fixed size columns. |
colSTRING256 | 7 | String column type with only 256 characters. This is needed for databases to allow queries on fixed size columns. |
colSTRING512 | 8 | String column type with only 512 characters. This is needed for databases to allow queries on fixed size columns. |
colBOOLEAN | 9 | Boolean column type. |
colOBJECT | 10 | Column type is a COM Object that supports IPersist stream. |
colSTRING1 | 11 | String column type with 1 character. This is needed for databases to allow queries on fixed size columns. |
colSTRING4 | 12 | String column type with only 4 characters. This is needed for databases to allow queries on fixed size columns. |
colSTRING8 | 13 | String column type with only 8 characters. This is needed for databases to allow queries on fixed size columns. |
colSTRING16 | 14 | String column type with only 16 characters. This is needed for databases to allow queries on fixed size columns. |
colSTRING32 | 15 | String column type with only 32 characters. This is needed for databases to allow queries on fixed size columns. |
colGEOMETRYPOINT | 16 | Esri geometry point column type. |
colGEOMETRYPOLYLINE | 17 | Esri geometry polyline column type. |
colGEOMETRYPOLYGON | 18 | Esri geometry polygon column type. |