5. SQL 92
5.3. FrontBase Datatypes
Table of Contents
FrontBase implements the following datatypes from SQL3:
BLOB, CLOB, BOOLEAN
Each type is explained below with an example of defining a column of the type.
BLOBA Binary Large OBject is an opaque binary datatype. The bytes you store are not interpreted in any way and are returned in the same form as when inserted. FrontBase implements
BLOBs very efficiently, including streaming on the server side so there is no unnecessary copying. Client side streaming is planned for a future version of FrontBase.
BLOBvalue can be up to 2 GB in size.
CREATE TABLE T0(C0 BLOB, ...);
CLOBA Character Large OBject is a datatype for very large character strings. Usually, these are strings that you don't want to search and for which you desire increased efficiency compared to
CLOBs are streamed on the server side so there is no unnecessary copying.
CLOBvalues are encoded in the UTF8 format with encoding and decoding occuring on the client side.
CREATE TABLE T0(C0 CLOB, ...);
BOOLEANImplemented as an unsigned byte. Please note that SQL 92 uses three-valued logic. The possible values for
CREATE TABLE T0(C0 BOOLEAN, ...);
If you have feedback or questions on this document, please send e-mail to firstname.lastname@example.org. Please reference the section number and topic. Thanks!!
©2000 FrontBase, Inc. All rights reserved.