DataDirect OpenAccess SDK Help

Data types

Save PDF

Table of Contents

Data types

Save PDF

Last Updated: May 12, 2026
2 minute read

OpenAccess SDK
Version 8.1
Documentation

The following table describes the supported SQL data types.

Supported SQL data types

SQL type	Description
BIGINT	Signed 64-bit integer.
BINARY (n)	Binary data of fixed length n (1 <= n <= 255).
BIT	Single bit binary data (0 or 1).
CHAR (n)	Character string of fixed string length n (1 <= n <=254).
DATE	Date data.
DECIMAL(p,s)	Signed, exact, numeric value with a precision p and scale s (1<=p<=127, 0<=s<=p).
DOUBLE PRECISION	Signed, approximate, numeric value with a mantissa precision 15 (0 or absolute value 10^-38 to 10³⁸)
FLOAT	Signed, approximate, numeric value with a mantissa precision 15 (0 or absolute value 10^-38 to 10³⁸)
INTEGER	Exact numeric value with precision 10 and scale 0. (signed: -2³¹ <=n <=2³¹-1, unsigned: 0<=n=2³²–1).
LONG VARCHAR	Variable-length string of any size less than 2 GB.
LONG VARBINARY	Variable-length binary data. Length is data source specific. Used for BLOB.
NUMERIC (p, s)	Signed, exact, numeric value with a precision p and scale s (1<=p<=127, 0<=s<=p).
REAL	Signed, approximate, numeric value with a mantissa precision 7 (0 or absolute value 10³⁸ to 10³⁸)
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	Exact numeric value with precision 3 and scale 0. signed: -128 <=n=127 unsigned: 0<=n<=255
VARCHAR (n)	Variable-length character string with a maximum string length which is data source dependent.
WCHAR (n)	Unicode character string of fixed string length n (1 <= n <=254).
WLONGVARCHAR	Variable-length Unicode string of any size < 2GB.
WVARCHAR (n)	Variable-length unicode character string with a maximum string length which is data source dependent.