Data types
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The OpenAccess SDK SQL engine supports the commonly used data types as defined in SQL92 and SQL99. This support allows each IP to expose its data in any of the supported types. The OpenAccess SDK client API libraries handle the conversions required to allow the client to ask for data in any format. The following table shows the data types that OpenAccess SDK supports.
Data types supported by OpenAccess SDK
| SQL Type | Description |
| BINARY | Binary stream of fixed length n (1 <= 254). |
| BIT | An integer data type that can take a value of 0 or 1. |
| CHAR(n) | Character string of fixed string length n (1 <= 254). |
| DATE | Date data. |
| DOUBLE PRECISION | Signed, approximate, numeric value with a mantissa precision 15 (zero or absolute value 10-38 to 1038). |
| FLOAT | Signed, approximate, numeric value with a mantissa precision 15 (zero or absolute value 10-38 to 1038). |
| INTEGER | Exact numeric value with precision 10 and scale 0. (signed: -231 <=n <=231-1, unsigned: 0<=n <=232-1). |
| LONGVARBINARY | Variable-length binary data; length is data source specific. This type is used for BLOB. |
| LONGVARCHAR | Variable-length character data with maximum string length data source dependent, with maximum length 2 GB |
| NUMERIC(p, s) | Signed, exact, numeric value with a precision p and scale s (1<=p<=40, 0<=s<=p) |
| REAL | Signed, approximate, numeric value with a mantissa precision 7 (zero or absolute value 10-38 to 1038) |
| SMALLINT | Exact numeric value with precision 5 and scale 0. (signed: -32,768 <=n <=32,767, unsigned:0<=n<=65,535). |
| TIME | Time data. |
| TIMESTAMP | Date/time data. |
| TINYINT | An integer value in the range of 0 to 255. |
| VARBINARY | Variable-length binary data; this type is deal for binary data of 4 KB or less. |
| VARCHAR(n) | Variable-length character string with a maximum string length data source dependent; this type is ideal for strings of 4 KB or less |
| WCHAR(n)1 | Unicode string of fixed string length n (1 ≤ n ≤ 254). |
| WLONGVARCHAR* | Variable-length Unicode character data with maximum string length data source dependent, with maximum length 2 GB. |
| WVARCHAR(n)* | Variable-length Unicode string with a maximum string length data source dependent. |
1 For Unicode use