1.1.1

The length is an unsigned integer constant for the length of value in bytes.
use byte[], java.io.InputStream, or java.lang.OutputStream as requiredEquivalent Java type
254 bytesMaximum length
1Default length
java.sql.Types.BINARYJDBC metadata type
ResultSet.getBytes, PreparedStatement.setBytesJDBC methods
use byte[] where requiredEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.BinaryADO.NET metadata type
BinaryADO.NET mapped System.Data.Dbtype
DbDataReader.GetBytesADO.NET getter
Syntax in CREATE TABLE
{ CHAR | CHARACTER }[(length)] FOR BIT DATA
CLOB
A character large object represents an array of characters of varying length. It is used to store large character-based
data such as documents.
The length of the CLOB is expressed in number of characters by default. The suffixes K, M, G stand for kilo,
mega and giga respectively.
java.sql.ClobEquivalent Java type
java.lang.Integer.MAX_VALUE (2147483647 )Maximum length
java.lang.Integer.MAX_VALUE (2147483647 )Default length
java.sql.Types.CLOBJDBC metadata type
ResultSet.getClob, PreparedStatement.setClobJDBC methods
no specific type; use char[] or stringEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.ClobADO.NET metadata type
StringADO.NET mapped System.Data.Dbtype
DbDataReader.GetChars, DbDataReader.GetStringADO.NET getter
Syntax in CREATE TABLE
{ CLOB | CHARACTER LARGE OBJECT } [ ( length [{ K | M | G }] ) ]
Example
CREATE TABLE clob_data(id INT primary key, text CLOB(10M));
–- search for a clob
select text from clob_data where id = 100;
vFabric SQLFire User's Guide626
vFabric SQLFire Reference