1.0

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;
DATE
Provides for storage of a date as year-month-day. Supported formats are:
yyyy-mm-dd
mm/dd/yyyy
dd.mm.yyyy
The year (yyyy) must always be expressed with four digits, while months (mm) and days (dd) may have either
one or two digits. DATEs, TIMEs, and TIMESTAMPs must not be mixed with one another in expressions except
with an explicit CAST.
java.sql.DateEquivalent Java type
java.sql.Types.DATEJDBC metadata type
ResultSet.getDate, PreparedStatement.setDateJDBC methods
System.DateTimeEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.DateADO.NET metadata type
DateADO.NET mapped System.Data.Dbtype
DbDataReader.GetDateTimeADO.NET getter
Example
VALUES '2010-05-04'
VALUES DATE('2001-10-12')
The latter example uses the DATE() function described in the section Built-in functions and procedures.
vFabric SQLFire User's Guide576
vFabric SQLFire Reference