Built-In Data Types
Built-in data types are data types that are defined by
the database server.
Built-In Data Type
1 BOOLEAN1
1 %BSON and JSON data types2
1 %Character Data Type3
1 %Numeric Data Type4
1 5 %Large-Object Data Type6
1 %Time Data Type7
1 IDSSECURITYLABEL8These data types are built into the database server in the sense that the information and support
functions required to interpret and transfer these data types is part of the database server
software, which supports character , numeric , large-object , and time
categories of built-in data types.
BOOLEAN and other built-in opaque data types HCL OneDB also supports the BOOLEAN data type, which is a built-in opaque data type that can store true, false, or NULL values. The symbol t represents a literal BOOLEAN true value, and f represents a literal BOOLEAN false value. BSON and JSON built-in opaque data types HCL OneDB that can be accessed and manipulated in local and distributed queries and in other DML operations. These are SQL data types that directly support relational database operations on data in BSON or JSON document store format. However, if you plan to query JSON and BSON data through the wire listener, you must create your database objects, such as collections and indexes, through the wire listener. You can use SQL statements to query JSON and BSON data whether you created your database objects through the wire listener or with SQL statements. Character Data Types IDSSECURITYLABEL Data Type HCL OneDB stores a security label. Numeric Data Types Exact Numeric Data Types Approximate Numeric Data Types Large-Object Data Types Time Data Types Have feedback? Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.