1.1

CHAR FOR BIT DATA
Provides for fixed-length byte strings. This is used when CHAR type is not appropriate due to unstructured data
or otherwise. If a value is shorter than the expected length, then it is padded with 0x20 byte values. No padding
is performed for comparisons between CHAR FOR BIT DATA and VARCHAR FOR BIT DATA types as per
SQL-92 standard (this is different from the way some DBMSs behave). An operation involving a VARCHAR
FOR BIT DATA and CHAR FOR BIT DATA yields a value of type VARCHAR FOR BIT DATA.
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 }] ) ]
vFabric SQLFire User's Guide606
vFabric SQLFire Reference