<html> <head> <title>Constants' Group DataType</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sdbc</a> :: </p> </td> </tr> <tr> <td class="title">constants group DataType</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>These constants are used to specify database data types which are used to identify the generic SQL types. The definition is based on JDBC 3.0. </dd> <dd><p> The actual type constant values are equivalent to those in the X/Open CLI. </p> <p> Precise information about the specfic types can be got from <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getTypeInfo">getTypeInfo()</a> .</p> </dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#BIT">BIT</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#TINYINT">TINYINT</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#SMALLINT">SMALLINT</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#INTEGER">INTEGER</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#BIGINT">BIGINT</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#FLOAT">FLOAT</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#REAL">REAL</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#DOUBLE">DOUBLE</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#NUMERIC">NUMERIC</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#DECIMAL">DECIMAL</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#CHAR">CHAR</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#VARCHAR">VARCHAR</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#LONGVARCHAR">LONGVARCHAR</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#DATE">DATE</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#TIME">TIME</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#TIMESTAMP">TIMESTAMP</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#BINARY">BINARY</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#VARBINARY">VARBINARY</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#LONGVARBINARY">LONGVARBINARY</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#SQLNULL">SQLNULL</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#OTHER">OTHER</a></td> <td class="imsum_right">indicates that the SQL type is database-specific and gets mapped to an object that can be accessed via the method <a href="XRow.html">XRow</a>::<a href="XRow.html#getObject">getObject()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#OBJECT">OBJECT</a></td> <td class="imsum_right">indicates a type which is represented by an object which implements this type. </td> </tr> <tr> <td class="imsum_left"><a href="#DISTINCT">DISTINCT</a></td> <td class="imsum_right">describes a type based on a built-in type. It is a user-defined data type (UDT). </td> </tr> <tr> <td class="imsum_left"><a href="#STRUCT">STRUCT</a></td> <td class="imsum_right">indicates a type consisting of attributes that may be any type. It is a user-defined data type (UDT). </td> </tr> <tr> <td class="imsum_left"><a href="#ARRAY">ARRAY</a></td> <td class="imsum_right">indicates a type representing an SQL ARRAY. </td> </tr> <tr> <td class="imsum_left"><a href="#BLOB">BLOB</a></td> <td class="imsum_right">indicates a type representing an SQL Binary Large Object. </td> </tr> <tr> <td class="imsum_left"><a href="#CLOB">CLOB</a></td> <td class="imsum_right">indicates a type representing an SQL Character Large Object. </td> </tr> <tr> <td class="imsum_left"><a href="#REF">REF</a></td> <td class="imsum_right">indicates a type representing an SQL REF, a referencing type. </td> </tr> <tr> <td class="imsum_left"><a href="#BOOLEAN">BOOLEAN</a></td> <td class="imsum_right">identifies the generic SQL type * <code>BOOLEAN</code>. * * </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="BIT" class="membertitle">BIT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>BIT</b> = -7;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TINYINT" class="membertitle">TINYINT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>TINYINT</b> = -6;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SMALLINT" class="membertitle">SMALLINT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SMALLINT</b> = 5;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="INTEGER" class="membertitle">INTEGER</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>INTEGER</b> = 4;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="BIGINT" class="membertitle">BIGINT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>BIGINT</b> = -5;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="FLOAT" class="membertitle">FLOAT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>FLOAT</b> = 6;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="REAL" class="membertitle">REAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>REAL</b> = 7;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DOUBLE" class="membertitle">DOUBLE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DOUBLE</b> = 8;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NUMERIC" class="membertitle">NUMERIC</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>NUMERIC</b> = 2;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DECIMAL" class="membertitle">DECIMAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DECIMAL</b> = 3;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CHAR" class="membertitle">CHAR</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>CHAR</b> = 1;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="VARCHAR" class="membertitle">VARCHAR</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>VARCHAR</b> = 12;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LONGVARCHAR" class="membertitle">LONGVARCHAR</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>LONGVARCHAR</b> = -1;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DATE" class="membertitle">DATE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DATE</b> = 91;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TIME" class="membertitle">TIME</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>TIME</b> = 92;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TIMESTAMP" class="membertitle">TIMESTAMP</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>TIMESTAMP</b> = 93;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="BINARY" class="membertitle">BINARY</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>BINARY</b> = -2;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="VARBINARY" class="membertitle">VARBINARY</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>VARBINARY</b> = -3;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LONGVARBINARY" class="membertitle">LONGVARBINARY</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>LONGVARBINARY</b> = -4;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SQLNULL" class="membertitle">SQLNULL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SQLNULL</b> = 0;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="OTHER" class="membertitle">OTHER</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>OTHER</b> = 1111;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates that the SQL type is database-specific and gets mapped to an object that can be accessed via the method <a href="XRow.html">XRow</a>::<a href="XRow.html#getObject">getObject()</a> . </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="OBJECT" class="membertitle">OBJECT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>OBJECT</b> = 2000;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates a type which is represented by an object which implements this type. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DISTINCT" class="membertitle">DISTINCT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DISTINCT</b> = 2001;<hr> <dl> <dt><b>Description</b></dt> <dd>describes a type based on a built-in type. It is a user-defined data type (UDT). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="STRUCT" class="membertitle">STRUCT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>STRUCT</b> = 2002;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates a type consisting of attributes that may be any type. It is a user-defined data type (UDT). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ARRAY" class="membertitle">ARRAY</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>ARRAY</b> = 2003;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates a type representing an SQL ARRAY. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="BLOB" class="membertitle">BLOB</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>BLOB</b> = 2004;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates a type representing an SQL Binary Large Object. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CLOB" class="membertitle">CLOB</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>CLOB</b> = 2005;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates a type representing an SQL Character Large Object. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="REF" class="membertitle">REF</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>REF</b> = 2006;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates a type representing an SQL REF, a referencing type. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="BOOLEAN" class="membertitle">BOOLEAN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>BOOLEAN</b> = 16;<hr> <dl> <dt><b>Description</b></dt> <dd>identifies the generic SQL type * <code>BOOLEAN</code>. * * </dd> <dt><b/></dt> <dd/></dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>