Creating an oa_types_info object
- Last Updated: May 12, 2026
- 3 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
An object of oa_types_info[] can be created using the new keyword. For example, oa_types_info[] xxxx = new oa_types_info[n].
where:
‘xxxx’ is the variable name and ‘n’ is an integer value.
The following code snippet illustrates how to create an oa_types_info object.
/* Overloaded Constructor*/
oa_types_info(String Typename, int Datatype, long OaPrecision,
String LiteralPrefix, String LiteralSuffix, String CreateParams,
int OaNullable, int OaCaseSensitive, int OaSearchable,
int UnsignedAttrib, int OaMoney, int AutoIncrement,
int MinimumScale, int MaximumScale, String LocaltypeName) */
oa_types_info[] typesInfo = new oa_types_info[22];
typesInfo[0] = new oa_types_info("CHAR", 1, 4096, "'", "'", "length", 1, 1, 3, 0, 0, 0, DAMOBJ_NOTSET, DAMOBJ_NOTSET, "CHAR");
…
typesInfo[21] = new oa_types_info("WLONGVARCHAR", -10, 2147483647, "N'", "'", "max length", 1, 1, 3, 0, 0, 0, DAMOBJ_NOTSET, DAMOBJ_NOTSET, "WLONGVARCHAR");
The following table contains different parameter values of the overloaded oa_types_info constructor that can be used to customize the information type.
Parameter Values for the overloaded constructor of oa_types_info
| Parameters | Values | |||
| Typename | WLONGVARCHAR | WVARCHAR | WCHAR | BIT |
| Datatype | -10 | -9 | -8 | -7 |
| OaPrecision | 2147483647 | 4096 | 4096 | 1 |
| LiteralPrefix | N' | N' | N' | <Null> |
| LiteralSuffix | ' | ' | <Null> | |
| CreateParams | max length | max length | length | <Null> |
| OaNullable | 1 | 1 | 1 | 1 |
| OaCaseSensitive | 1 | 1 | 1 | 0 |
| OaSearchable | 3 | 3 | 3 | 2 |
| UnsignedSttrib | <Null> | <Null> | <Null> | <Null> |
| OaMoney | 0 | 0 | 0 | 0 |
| AutoIncrement | <Null> | <Null> | <Null> | <Null> |
| MinimumScale | <Null> | <Null> | <Null> | 0 |
| maximumScale | <Null> | <Null> | <Null> | 0 |
| LocaltypeName | WLONGVARCHAR | WVARCHAR | WCHAR | BIT |
Parameter Values for the overloaded constructor of oa_types_info
| Parameters | Values | |||
| Typename | TINYINT | BIGINT | LONGVARBINARY | VARBINARY |
| Datatype | -6 | -5 | -4 | -3 |
| OaPrecision | 3 | 19 | 2147483647 | 4096 |
| LiteralPrefix | <Null> | <Null> | 0x | 0x |
| LiteralSuffix | <Null> | <Null> | <Null> | <Null> |
| CreateParams | <Null> | <Null> | max length | max length |
| OaNullable | 1 | 1 | 1 | 1 |
| OaCaseSensitive | 0 | 0 | 0 | 0 |
| OaSearchable | 2 | 2 | 0 | 0 |
| UnsignedSttrib | 1 | 0 | <Null> | <Null> |
| OaMoney | 0 | 0 | 0 | 0 |
| AutoIncrement | 0 | 0 | <Null> | <Null> |
| MinimumScale | 0 | 0 | <Null> | <Null> |
| maximumScale | 0 | 0 | <Null> | <Null> |
| LocaltypeName | TINYINT | BIGINT | LONGVARBINARY | VARBINARY |
Parameter Values for the overloaded constructor of oa_types_info
| Parameters | Values | |||
| Typename | BINARY | LONGVARCHAR | NULL | CHAR |
| Datatype | -2 | -1 | 0 | 1 |
| OaPrecision | 4096 | 2147483647 | 1 | 4096 |
| LiteralPrefix | 0x | ' | <Null> | |
| LiteralSuffix | <Null> | ' | <Null> | ' |
| CreateParams | length | max length | <Null> | length |
| OaNullable | 1 | 1 | 1 | 1 |
| OaCaseSensitive | 0 | 1 | 0 | 1 |
| OaSearchable | 0 | 3 | 2 | 3 |
| UnsignedSttrib | <Null> | <Null> | <Null> | <Null> |
| OaMoney | 0 | 0 | 0 | 0 |
| AutoIncrement | <Null> | <Null> | <Null> | <Null> |
| MinimumScale | <Null> | <Null> | <Null> | <Null> |
| maximumScale | <Null> | <Null> | <Null> | <Null> |
| LocaltypeName | BINARY | LONGVARCHAR | NULL | CHAR |
Parameter values for the overloaded constructor of oa_types_info
| Parameters | Values | |||
| Typename | NUMERIC | INTEGER | SMALLINT | REAL |
| Datatype | 2 | 4 | 5 | 7 |
| OaPrecision | 40 | 10 | 5 | 24 |
| LiteralPrefix | <Null> | <Null> | <Null> | <Null> |
| LiteralSuffix | <Null> | <Null> | <Null> | <Null> |
| CreateParams | precisionscale | <Null> | <Null> | <Null> |
| OaNullable | 1 | 1 | 1 | 1 |
| OaCaseSensitive | 0 | 0 | 0 | 0 |
| OaSearchable | 2 | 2 | 2 | 2 |
| UnsignedSttrib | 0 | 0 | 0 | 0 |
| OaMoney | 0 | 0 | 0 | 0 |
| AutoIncrement | 0 | 0 | 0 | 0 |
| MinimumScale | 0 | 0 | 0 | <Null> |
| maximumScale | 32 | 0 | 0 | <Null> |
| LocaltypeName | NUMERIC | INTEGER | SMALLINT | REAL |
Parameter values for the overloaded constructor of oa_types_info
| Parameters | Values | ||||
| Typename | DOUBLE | VARCHAR | DATE | TIME | TIMESTAMP |
| Datatype | 8 | 12 | 91 | 92 | 93 |
| OaPrecision | 53 | 4096 | 10 | 8 | 19 |
| LiteralPrefix | <Null> | ' | ' | ' | |
| LiteralSuffix | <Null> | ' | ' | ||
| CreateParams | <Null> | max length | <Null> | <Null> | <Null> |
| OaNullable | 1 | 1 | 1 | 1 | 1 |
| OaCaseSensitive | 0 | 1 | 0 | 0 | 0 |
| OaSearchable | 2 | 3 | 2 | 2 | 2 |
| UnsignedSttrib | 0 | <Null> | <Null> | <Null> | <Null> |
| OaMoney | 0 | 0 | 0 | 0 | 0 |
| AutoIncrement | 0 | <Null> | <Null> | <Null> | <Null> |
| MinimumScale | <Null> | <Null> | <Null> | <Null> | 0 |
| maximumScale | <Null> | <Null> | <Null> | <Null> | 0 |
| LocaltypeName | DOUBLE | VARCHAR | DATE | TIME | TIMESTAMP |