BYTE and TEXT data types

This section describes the HCL OneDB™ BYTE and TEXT data types and how to manipulate columns of these data types with the JDBC API.

The BYTE data type is a data type for a simple large object that stores any data in an undifferentiated byte stream. Examples of this binary data include spreadsheets, digitized voice patterns, and video clips. The TEXT data type is a data type for a simple large object that stores any text data. It can contain both single and multibyte characters.

Columns of either data type have a theoretical limit of 2³¹ bytes and a practical limit determined by your disk capacity.

For more detailed information about the HCL OneDB BYTE and TEXT data types, see HCL OneDB Guide to SQL: Reference and HCL OneDB Guide to SQL: Syntax.