Reference tables
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
This section contains tables referenced by the APIs listed in this section. The following table represents the .NET data types that the .NET code must use when calling the OpenAccess SDK SQL Engine methods for .NET.
OpenAccess data types and .NET type when adding value
| SQL Type | Data Type – use with API calls | .NET Data Types |
| BIGINT | XO_TYPE_BIGINT | long |
| BINARY | XO_TYPE_BINARY | byte [ ] |
| BIT | XO_TYPE_BIT | bool |
| CHAR | XO_TYPE_CHAR | StringBuilder – string of characters |
| DATE | XO_TYPE_DATE | DateTime – create this object using DateTime(year, month, day) |
| DOUBLE | XO_TYPE_DOUBLE | double |
| FLOAT | XO_TYPE_FLOAT | double |
| INTEGER | XO_TYPE_INTEGER | int |
| LONGVARBINARY | XO_TYPE_LONGVARBINARY | byte [ ] |
| LONGVARCHAR | XO_TYPE_LONGVARCHAR | StringBuilder – string of characters |
| NUMERIC | XO_TYPE_NUMERIC | StringBuilder – a string with a decimal point. Does not have to be padded for exact precision and scale specifications. |
| REAL | XO_TYPE_REAL | float |
| SMALLINT | XO_TYPE_SMALLINT | short |
| TIME | XO_TYPE_TIME | DateTime – create this object using DateTime(hour, minute, second, fraction) |
| TIMESTAMP | XO_TYPE_TIMESTAMP | DateTime – create this object using DateTime(year, month, day, hour, minute, second, fraction) |
| TINYINT | XO_TYPE_TINYINT | byte [ ] |
| VARBINARY | XO_TYPE_VARBINARY | byte [ ] |
| VARCHAR | XO_TYPE_VARCHAR | StringBuilder – string of characters |
| WCHAR | XO_TYPE_WCHAR | StringBuilder – string of Unicode characters |
| WLONGVARCHAR | XO_TYPE_WLONGVARCHAR | StringBuilder – string of Unicode characters |
| WVARCHAR | XO_TYPE_WVARCHAR | StringBuilder – string of Unicode characters |
Table 34 details how an object is interpreted when returned from a method. The class of the object returned by the methods depends on the type of the column or the condition. For example, if the left condition value type is XO_TYPE_CHAR, then calling dam_getCondVal on that condition will return an object of type String.
How the methods for .NET return a value as an object
| XO type of the condition or the column | Class type of the returned object |
| XO_TYPE_BIGINT | long |
| XO_TYPE_BINARY | byte [ ] |
| XO_TYPE_BIT | bool |
| XO_TYPE_CHAR | string |
| XO_TYPE_DATE | DateTime |
| XO_TYPE_DOUBLE | double |
| XO_TYPE_FLOAT | double |
| XO_TYPE_INTEGER | Integer |
| XO_TYPE_LONGVARBINARY | byte [ ] |
| XO_TYPE_LONGVARCHAR | string |
| XO_TYPE_NUMERIC | string |
| XO_TYPE_REAL | float |
| XO_TYPE_SMALLINT | short |
| XO_TYPE_TIME | DateTime |
| XO_TYPE_TIMESTAMP | DateTime |
| XO_TYPE_TINYINT | byte [ ] |
| XO_TYPE_VARBINARY | byte [ ] |
| XO_TYPE_VARCHAR | string - string of characters |
| XO_TYPE_WCHAR | string |
| XO_TYPE_WLONGVARCHAR | string |
| XO_TYPE_WVARCHAR | string |