1.0

java.lang.Long.MAX_VALUE (9223372036854775807 )Maximum value
java.sql.Types.BIGINTJDBC metadata type
ResultSet.getLong, PreparedStatement.setLongJDBC methods
System.Int64Equivalent .NET type
Vmware.Data.SQLFire.SQLFType.LongADO.NET metadata type
Int64ADO.NET mapped System.Data.Dbtype
DbDataReader.GetInt64ADO.NET getter
BLOB
A binary large object represents an array of raw bytes of varying length.
java.lang.BlobEquivalent Java type
java.lang.Integer.MAX_VALUE (2147483647 )Maximum length (also default length)
java.sql.Types.BLOBJDBC metadata type
ResultSet.getBlob, PreparedStatement.setBlobJDBC methods
no specific type mapping; use byte[] where requiredEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.BlobADO.NET metadata type
BinaryADO.NET mapped System.Data.Dbtype
DbDataReader.GetBytesADO.NET getter
Syntax in CREATE TABLE
{ BLOB | BINARY LARGE OBJECT } [ ( length [{ K | M | G }] ) ]
The length of the BLOB is expressed in number of bytes by default. The suffixes K, M, G stand for kilobyte,
megabyte and gigabyte respectively.
Example
CREATE TABLE blob_data(id INT primary key, data BLOB(10M));
–- search for a blob
select length(data) from blob_data where id = 100;
CHAR
Provides for fixed-length strings. If a string value is shorter than the expected length, then spaces are inserted
to pad the string to the expected length. If a string value is longer than the expected length, then any trailing
blanks are trimmed to make the length same as the expected length, while an exception is raised if characters
other than spaces are required to be truncated. For comparision operations, the shorter CHAR string is padded
with spaces to the longer value. Similarly when mixing CHARs and VARCHARs in expressions , the shorter
value is padded with spaces to the length of longer string.
To represent a single quotation mark within a string, use two quotation marks:
VALUES 'going to Chandra''s place'
The length of CHAR is an unsigned integer constant.
java.lang.StringEquivalent Java type
vFabric SQLFire User's Guide574
vFabric SQLFire Reference