Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Data TypeThe Data Type segment specifies the data type of a column, of a component of a collection, of a field within a ROW type, of a routine parameter, or of a value returned by an expression or by a cast function. Use this segment whenever you see a reference to a data type in a syntax diagram.
Built-In Data Types
Large-Object Data Types
Simple-large-object data typesA simple large object data type stores text or binary data in blobspaces.

Simple-large-object data types

A simple large object data type stores text or binary data in blobspaces.

These are the simple-large-object data types:

TEXT: Stores text data of up to 2³¹ bytes
BYTE: Stores any digitized data of up to 2³¹ bytes

Do not supply a BYTE value where TEXT is expected. No built-in cast supports BYTE to TEXT data type conversion.

Because of the maximum row size limit of 32,767 bytes, you cannot create a table with more than approximately 195 BYTE or TEXT columns. (This restriction also applies to all varying-length data types and ROW data types.)

For more information about the simple large object data types, see the HCL OneDB™ Guide to SQL: Reference.

For information on how to create blobspaces, see your HCL OneDB Administrator's Guide.

For information about optical families, see the .