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 IDSSECURITYLABEL8
These 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 The BSON and JSON data types are built-in opaque types of 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 In a table that is protected by a label-based security policy, the IDSSECURITYLABEL data type of HCL OneDB stores a security label. Numeric Data Types Exact Numeric Data Types Approximate Numeric Data Types Large-Object Data Types Time Data Types The time data types store calendar dates, points in time, and intervals of time.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.