1.1

Syntax in CREATE TABLE
{ VARCHAR | CHAR VARYING | CHARACTER VARYING }(length)
VARCHAR FOR BIT DATA
Provides for variable-length byte strings with a maximum limit for length. This is used when character types are
not appropriate due to unstructured data or otherwise. 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 type of a byte literal is always a VARCHAR FOR BIT DATA, not a CHAR FOR BIT DATA.
The length is an unsigned integer constant for the length of value in bytes.
use byte[] or java.io.InputStream / java.lang.OutputStream as requiredEquivalent Java type
32672 bytesMaximum length
java.sql.Types.VARBINARYJDBC metadata type
ResultSet.getBytes, PreparedStatement.setBytesJDBC methods
use byte[] where requiredEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.VarBinaryADO.NET metadata type
BinaryADO.NET mapped System.Data.Dbtype
DbDataReader.GetBytesADO.NET getter
Syntax in CREATE TABLE
{ VARCHAR | CHAR VARYING | CHARACTER VARYING }[(length)] FOR BIT DATA
XML
This type can be used for Extensible Markup Language (XML) documents:
• to store XML documents that conform to the SQL/XML definition of a well-formed XML(DOCUMENT(ANY))
value
• Transiently for XML(SEQUENCE) values, that might not be well-formed XML(DOCUMENT(ANY)) values
Note:
SQLFire does not support the SQLXML type from the SQL standard, or the java SQLXML type, rather
the values are stored as normal strings and user must use XMLSERIALIZE, XMLPARSE functions
explicitly for inserts and queries as appropriate.
For an application to execute XML related functions, the application must either use a JDK having inbuilt
JAXP/Xalan support (e.g. Sun JDK5) or must have classes for a JAXP parser and for Xalan in the server classpath
(serializer.jar, xalan.jar).
To fetch XML values from a SQLFire database using JDBC or ADO.NET drivers, use the XMLSERIALIZE
operator in the SQL query. For example:
SELECT XMLSERIALIZE(doc as CLOB) FROM t1
vFabric SQLFire User's Guide614
vFabric SQLFire Reference