Types

Documentation of 'org.hsqldb.types.Types' Java class Types

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

java.lang.Object
- org.hsqldb.types.Types

```
public class Types
extends java.lang.Object
```
Defines the constants that are used to identify SQL types for HSQLDB JDBC inteface type reporting. The actual type constant values are equivalent to those defined in the latest java.sql.Types, where available, or those defined by ansi/iso SQL 2003 otherwise. A type sub-identifer has been added to differentiate HSQLDB-specific type specializations.

Since:

1.7.2

Field Summary

Fields
Modifier and Type	Field and Description
`static int[][]`	`ALL_TYPES` Every (type,type-sub) combination known in the HSQLDB context.
`static int`	`ARRAY` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ARRAY`.
`static int`	`BIGINT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIGINT`.
`static int`	`BINARY` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BINARY`.
`static int`	`BIT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIT`.
`static int`	`BLOB` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BLOB`.
`static java.lang.String`	`BlobClassName`
`static int`	`BOOLEAN` The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type `BOOLEAN`.
`static int`	`CHAR` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CHAR`.
`static int`	`CLOB` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CLOB`
`static java.lang.String`	`ClobClassName`
`static int`	`DATALINK` The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type `DATALINK`.
`static int`	`DATE` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATE`.
`static java.lang.String`	`DateClassName`
`static int`	`DECIMAL` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DECIMAL`.
`static java.lang.String`	`DecimalClassName` Names of types returned by JDBC methods and accepted as library and user function arguments
`static int`	`DISTINCT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DISTINCT`.
`static int`	`DOUBLE` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DOUBLE`.
`static int`	`FLOAT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `FLOAT`.
`static int`	`INTEGER` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `INTEGER`.
`static int`	`JAVA_OBJECT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `JAVA_OBJECT`.
`static int`	`LONGNVARCHAR` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGNVARCHAR`.
`static int`	`LONGVARBINARY` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARBINARY`.
`static int`	`LONGVARCHAR` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARCHAR`.
`static int`	`MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE` A reasonable/customizable number to avoid the shortcomings/defects associated with doing a dynamic scan of results to determine the value.
`static int`	`MULTISET` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `MULTISET`.
`static int`	`NCHAR` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCHAR`
`static int`	`NCLOB` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCLOB`.
`static int`	`NULL` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NULL`.
`static int`	`NUMERIC` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NUMERIC`.
`static int`	`NVARCHAR` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NVARCHAR`.
`static int`	`OTHER` The constant in the Java programming language that indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods `getObject` and `setObject`.
`static int`	`REAL` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REAL`.
`static int`	`REF` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REF`.
`static int`	`ROWID` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ROWID`
`static int`	`SMALLINT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `SMALLINT`.
`static int`	`SQL_ALL_TYPES`
`static int`	`SQL_ARRAY`
`static int`	`SQL_ARRAY_LOCATOR`
`static int`	`SQL_BIGINT`
`static int`	`SQL_BINARY`
`static int`	`SQL_BIT`
`static int`	`SQL_BIT_VARYING`
`static int`	`SQL_BLOB`
`static int`	`SQL_BLOB_LOCATOR`
`static int`	`SQL_BOOLEAN`
`static int`	`SQL_CHAR`
`static int`	`SQL_CLOB`
`static int`	`SQL_CLOB_LOCATOR`
`static int`	`SQL_DATALINK`
`static int`	`SQL_DATE`
`static int`	`SQL_DATETIME`
`static int`	`SQL_DECIMAL`
`static int`	`SQL_DOUBLE`
`static int`	`SQL_FLOAT`
`static int`	`SQL_GUID`
`static int`	`SQL_IMAGE`
`static int`	`SQL_INTEGER`
`static int`	`SQL_INTERVAL`
`static int`	`SQL_INTERVAL_DAY`
`static int`	`SQL_INTERVAL_DAY_TO_HOUR`
`static int`	`SQL_INTERVAL_DAY_TO_MINUTE`
`static int`	`SQL_INTERVAL_DAY_TO_SECOND`
`static int`	`SQL_INTERVAL_HOUR`
`static int`	`SQL_INTERVAL_HOUR_TO_MINUTE`
`static int`	`SQL_INTERVAL_HOUR_TO_SECOND`
`static int`	`SQL_INTERVAL_MINUTE`
`static int`	`SQL_INTERVAL_MINUTE_TO_SECOND`
`static int`	`SQL_INTERVAL_MONTH`
`static int`	`SQL_INTERVAL_SECOND`
`static int`	`SQL_INTERVAL_YEAR`
`static int`	`SQL_INTERVAL_YEAR_TO_MONTH`
`static int`	`SQL_LONGVARBINARY`
`static int`	`SQL_MULTISET`
`static int`	`SQL_MULTISET_LOCATOR`
`static int`	`SQL_NCHAR`
`static int`	`SQL_NTEXT`
`static int`	`SQL_NUMERIC`
`static int`	`SQL_NVARCHAR`
`static int`	`SQL_REAL`
`static int`	`SQL_REF`
`static int`	`SQL_ROW`
`static int`	`SQL_SMALLINT`
`static int`	`SQL_SUB_DISTINCT`
`static int`	`SQL_SUB_STRUCTURED`
`static int`	`SQL_TIME`
`static int`	`SQL_TIME_WITH_TIME_ZONE`
`static int`	`SQL_TIMESTAMP`
`static int`	`SQL_TIMESTAMP_WITH_TIME_ZONE`
`static int`	`SQL_TYPE_NUMBER_LIMIT`
`static int`	`SQL_UDT`
`static int`	`SQL_UDT_LOCATOR`
`static int`	`SQL_USER_DEFINED_TYPE`
`static int`	`SQL_VARBINARY`
`static int`	`SQL_VARCHAR`
`static int`	`SQL_VARIANT`
`static int`	`SQL_WCHAR`
`static int`	`SQL_WLONGVARCHAR`
`static int`	`SQL_WVARCHAR`
`static int`	`SQL_XML`
`static int`	`SQLXML` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `XML`.
`static int`	`STRUCT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `STRUCT`.
`static int`	`TIME` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIME`.
`static java.lang.String`	`TimeClassName`
`static int`	`TIMESTAMP` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP`.
`static java.lang.String`	`TimestampClassName`
`static int`	`TINYINT` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TINYINT`.
`static int`	`TYPE_SUB_DEFAULT` The default HSQLODB type sub-identifier.
`static int`	`VARBINARY` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `VARBINARY`.
`static int`	`VARCHAR` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `VARCHAR`.
`static int`	`VARCHAR_IGNORECASE`

Constructor Summary

Constructors
Constructor and Description

Types()

Constructors
Constructor and Description
`Types()`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static boolean`	`acceptsPrecision(int type)` Types that accept precision params in column definition or casts.
`static boolean`	`acceptsScaleCreateParam(int type)`
`static boolean`	`acceptsZeroPrecision(int type)`
`static Type`	`getParameterSQLType(java.lang.Class c)` Retieves the type object corresponding to the class of an IN, IN OUT or OUT parameter or a return type.
`static boolean`	`isSearchable(int type)`
`static boolean`	`requiresPrecision(int type)`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - DecimalClassName
```
public static final java.lang.String DecimalClassName
```
    Names of types returned by JDBC methods and accepted as library and user function arguments
    
    See Also:
    
    Constant Field Values
  - DateClassName
```
public static final java.lang.String DateClassName
```
    See Also:
    
    Constant Field Values
  - TimeClassName
```
public static final java.lang.String TimeClassName
```
    See Also:
    
    Constant Field Values
  - TimestampClassName
```
public static final java.lang.String TimestampClassName
```
    See Also:
    
    Constant Field Values
  - BlobClassName
```
public static final java.lang.String BlobClassName
```
    See Also:
    
    Constant Field Values
  - ClobClassName
```
public static final java.lang.String ClobClassName
```
    See Also:
    
    Constant Field Values
  - SQL_CHAR
```
public static final int SQL_CHAR
```
    See Also:
    
    Constant Field Values
  - SQL_NUMERIC
```
public static final int SQL_NUMERIC
```
    See Also:
    
    Constant Field Values
  - SQL_DECIMAL
```
public static final int SQL_DECIMAL
```
    See Also:
    
    Constant Field Values
  - SQL_INTEGER
```
public static final int SQL_INTEGER
```
    See Also:
    
    Constant Field Values
  - SQL_SMALLINT
```
public static final int SQL_SMALLINT
```
    See Also:
    
    Constant Field Values
  - SQL_FLOAT
```
public static final int SQL_FLOAT
```
    See Also:
    
    Constant Field Values
  - SQL_REAL
```
public static final int SQL_REAL
```
    See Also:
    
    Constant Field Values
  - SQL_DOUBLE
```
public static final int SQL_DOUBLE
```
    See Also:
    
    Constant Field Values
  - SQL_VARCHAR
```
public static final int SQL_VARCHAR
```
    See Also:
    
    Constant Field Values
  - SQL_BOOLEAN
```
public static final int SQL_BOOLEAN
```
    See Also:
    
    Constant Field Values
  - SQL_USER_DEFINED_TYPE
```
public static final int SQL_USER_DEFINED_TYPE
```
    See Also:
    
    Constant Field Values
  - SQL_ROW
```
public static final int SQL_ROW
```
    See Also:
    
    Constant Field Values
  - SQL_REF
```
public static final int SQL_REF
```
    See Also:
    
    Constant Field Values
  - SQL_BIGINT
```
public static final int SQL_BIGINT
```
    See Also:
    
    Constant Field Values
  - SQL_BLOB
```
public static final int SQL_BLOB
```
    See Also:
    
    Constant Field Values
  - SQL_CLOB
```
public static final int SQL_CLOB
```
    See Also:
    
    Constant Field Values
  - SQL_ARRAY
```
public static final int SQL_ARRAY
```
    See Also:
    
    Constant Field Values
  - SQL_MULTISET
```
public static final int SQL_MULTISET
```
    See Also:
    
    Constant Field Values
  - SQL_BINARY
```
public static final int SQL_BINARY
```
    See Also:
    
    Constant Field Values
  - SQL_VARBINARY
```
public static final int SQL_VARBINARY
```
    See Also:
    
    Constant Field Values
  - SQL_DATE
```
public static final int SQL_DATE
```
    See Also:
    
    Constant Field Values
  - SQL_TIME
```
public static final int SQL_TIME
```
    See Also:
    
    Constant Field Values
  - SQL_TIMESTAMP
```
public static final int SQL_TIMESTAMP
```
    See Also:
    
    Constant Field Values
  - SQL_TIME_WITH_TIME_ZONE
```
public static final int SQL_TIME_WITH_TIME_ZONE
```
    See Also:
    
    Constant Field Values
  - SQL_TIMESTAMP_WITH_TIME_ZONE
```
public static final int SQL_TIMESTAMP_WITH_TIME_ZONE
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_YEAR
```
public static final int SQL_INTERVAL_YEAR
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_MONTH
```
public static final int SQL_INTERVAL_MONTH
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_DAY
```
public static final int SQL_INTERVAL_DAY
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_HOUR
```
public static final int SQL_INTERVAL_HOUR
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_MINUTE
```
public static final int SQL_INTERVAL_MINUTE
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_SECOND
```
public static final int SQL_INTERVAL_SECOND
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_YEAR_TO_MONTH
```
public static final int SQL_INTERVAL_YEAR_TO_MONTH
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_DAY_TO_HOUR
```
public static final int SQL_INTERVAL_DAY_TO_HOUR
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_DAY_TO_MINUTE
```
public static final int SQL_INTERVAL_DAY_TO_MINUTE
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_DAY_TO_SECOND
```
public static final int SQL_INTERVAL_DAY_TO_SECOND
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_HOUR_TO_MINUTE
```
public static final int SQL_INTERVAL_HOUR_TO_MINUTE
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_HOUR_TO_SECOND
```
public static final int SQL_INTERVAL_HOUR_TO_SECOND
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL_MINUTE_TO_SECOND
```
public static final int SQL_INTERVAL_MINUTE_TO_SECOND
```
    See Also:
    
    Constant Field Values
  - SQL_TYPE_NUMBER_LIMIT
```
public static final int SQL_TYPE_NUMBER_LIMIT
```
    See Also:
    
    Constant Field Values
  - SQL_BIT
```
public static final int SQL_BIT
```
    See Also:
    
    Constant Field Values
  - SQL_BIT_VARYING
```
public static final int SQL_BIT_VARYING
```
    See Also:
    
    Constant Field Values
  - SQL_DATALINK
```
public static final int SQL_DATALINK
```
    See Also:
    
    Constant Field Values
  - SQL_UDT
```
public static final int SQL_UDT
```
    See Also:
    
    Constant Field Values
  - SQL_UDT_LOCATOR
```
public static final int SQL_UDT_LOCATOR
```
    See Also:
    
    Constant Field Values
  - SQL_BLOB_LOCATOR
```
public static final int SQL_BLOB_LOCATOR
```
    See Also:
    
    Constant Field Values
  - SQL_CLOB_LOCATOR
```
public static final int SQL_CLOB_LOCATOR
```
    See Also:
    
    Constant Field Values
  - SQL_ARRAY_LOCATOR
```
public static final int SQL_ARRAY_LOCATOR
```
    See Also:
    
    Constant Field Values
  - SQL_MULTISET_LOCATOR
```
public static final int SQL_MULTISET_LOCATOR
```
    See Also:
    
    Constant Field Values
  - SQL_ALL_TYPES
```
public static final int SQL_ALL_TYPES
```
    See Also:
    
    Constant Field Values
  - SQL_DATETIME
```
public static final int SQL_DATETIME
```
    See Also:
    
    Constant Field Values
  - SQL_INTERVAL
```
public static final int SQL_INTERVAL
```
    See Also:
    
    Constant Field Values
  - SQL_XML
```
public static final int SQL_XML
```
    See Also:
    
    Constant Field Values
  - SQL_NCHAR
```
public static final int SQL_NCHAR
```
    See Also:
    
    Constant Field Values
  - SQL_WCHAR
```
public static final int SQL_WCHAR
```
    See Also:
    
    Constant Field Values
  - SQL_WVARCHAR
```
public static final int SQL_WVARCHAR
```
    See Also:
    
    Constant Field Values
  - SQL_NVARCHAR
```
public static final int SQL_NVARCHAR
```
    See Also:
    
    Constant Field Values
  - SQL_WLONGVARCHAR
```
public static final int SQL_WLONGVARCHAR
```
    See Also:
    
    Constant Field Values
  - SQL_NTEXT
```
public static final int SQL_NTEXT
```
    See Also:
    
    Constant Field Values
  - SQL_LONGVARBINARY
```
public static final int SQL_LONGVARBINARY
```
    See Also:
    
    Constant Field Values
  - SQL_IMAGE
```
public static final int SQL_IMAGE
```
    See Also:
    
    Constant Field Values
  - SQL_GUID
```
public static final int SQL_GUID
```
    See Also:
    
    Constant Field Values
  - SQL_VARIANT
```
public static final int SQL_VARIANT
```
    See Also:
    
    Constant Field Values
  - SQL_SUB_DISTINCT
```
public static final int SQL_SUB_DISTINCT
```
    See Also:
    
    Constant Field Values
  - SQL_SUB_STRUCTURED
```
public static final int SQL_SUB_STRUCTURED
```
    See Also:
    
    Constant Field Values
  - VARCHAR_IGNORECASE
```
public static final int VARCHAR_IGNORECASE
```
    See Also:
    
    Constant Field Values
  - ARRAY
```
public static final int ARRAY
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - BIGINT
```
public static final int BIGINT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.
    
    See Also:
    
    Constant Field Values
  - BINARY
```
public static final int BINARY
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.
    
    See Also:
    
    Constant Field Values
  - BIT
```
public static final int BIT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.
    
    See Also:
    
    Constant Field Values
  - BLOB
```
public static final int BLOB
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - BOOLEAN
```
public static final int BOOLEAN
```
    The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
    
    Since:
    
    JDK 1.4
    
    See Also:
    
    Constant Field Values
  - CHAR
```
public static final int CHAR
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.
    
    See Also:
    
    Constant Field Values
  - CLOB
```
public static final int CLOB
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - DATALINK
```
public static final int DATALINK
```
    The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type DATALINK.
    
    Since:
    
    JDK 1.4
    
    See Also:
    
    Constant Field Values
  - DATE
```
public static final int DATE
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.
    
    See Also:
    
    Constant Field Values
  - DECIMAL
```
public static final int DECIMAL
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.
    
    See Also:
    
    Constant Field Values
  - DISTINCT
```
public static final int DISTINCT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - DOUBLE
```
public static final int DOUBLE
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.
    
    See Also:
    
    Constant Field Values
  - FLOAT
```
public static final int FLOAT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.
    
    See Also:
    
    Constant Field Values
  - INTEGER
```
public static final int INTEGER
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.
    
    See Also:
    
    Constant Field Values
  - JAVA_OBJECT
```
public static final int JAVA_OBJECT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - LONGVARBINARY
```
public static final int LONGVARBINARY
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.
    
    See Also:
    
    Constant Field Values
  - LONGVARCHAR
```
public static final int LONGVARCHAR
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.
    
    See Also:
    
    Constant Field Values
  - MULTISET
```
public static final int MULTISET
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type MULTISET.
    
    See Also:
    
    Constant Field Values
  - NULL
```
public static final int NULL
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NULL.
    
    See Also:
    
    Constant Field Values
  - NUMERIC
```
public static final int NUMERIC
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.
    
    See Also:
    
    Constant Field Values
  - OTHER
```
public static final int OTHER
```
    The constant in the Java programming language that indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject.
    
    See Also:
    
    Constant Field Values
  - REAL
```
public static final int REAL
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.
    
    See Also:
    
    Constant Field Values
  - REF
```
public static final int REF
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - SMALLINT
```
public static final int SMALLINT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.
    
    See Also:
    
    Constant Field Values
  - STRUCT
```
public static final int STRUCT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.
    
    Since:
    
    JDK 1.2
    
    See Also:
    
    Constant Field Values
  - TIME
```
public static final int TIME
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.
    
    See Also:
    
    Constant Field Values
  - TIMESTAMP
```
public static final int TIMESTAMP
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.
    
    See Also:
    
    Constant Field Values
  - TINYINT
```
public static final int TINYINT
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.
    
    See Also:
    
    Constant Field Values
  - VARBINARY
```
public static final int VARBINARY
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.
    
    See Also:
    
    Constant Field Values
  - VARCHAR
```
public static final int VARCHAR
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.
    
    See Also:
    
    Constant Field Values
  - ROWID
```
public static final int ROWID
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID
    
    Since:
    
    JDK 1.6, HSQLDB 1.8.x
    
    See Also:
    
    Constant Field Values
  - NCHAR
```
public static final int NCHAR
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR
    
    Since:
    
    JDK 1.6, HSQLDB 1.8.x
    
    See Also:
    
    Constant Field Values
  - NVARCHAR
```
public static final int NVARCHAR
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.
    
    Since:
    
    JDK 1.6, HSQLDB 1.8.x
    
    See Also:
    
    Constant Field Values
  - LONGNVARCHAR
```
public static final int LONGNVARCHAR
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.
    
    Since:
    
    JDK 1.6, HSQLDB 1.8.x
    
    See Also:
    
    Constant Field Values
  - NCLOB
```
public static final int NCLOB
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.
    
    Since:
    
    JDK 1.6, HSQLDB 1.8.x
    
    See Also:
    
    Constant Field Values
  - SQLXML
```
public static final int SQLXML
```
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.
    
    Since:
    
    JDK 1.6, HSQLDB 1.8.x
    
    See Also:
    
    Constant Field Values
  - TYPE_SUB_DEFAULT
```
public static final int TYPE_SUB_DEFAULT
```
    The default HSQLODB type sub-identifier. This indicates that an HSQLDB type with this sub-type, if supported, is the very closest thing HSQLDB offerers to the JDBC/SQL2003 type
    
    See Also:
    
    Constant Field Values
  - ALL_TYPES
```
public static final int[][] ALL_TYPES
```
    Every (type,type-sub) combination known in the HSQLDB context. Not every combination need be supported as a table or procedure column type -- such determinations are handled in DITypeInfo.
  - MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE
```
public static final int MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE
```
    A reasonable/customizable number to avoid the shortcomings/defects associated with doing a dynamic scan of results to determine the value. In practice, it turns out that single query yielding widely varying values for display size of CHAR and VARCHAR columns on repeated execution results in patently poor usability, as some fairly high-profile, otherwise "enterprise-quality" RAD tools depend on on the first value returned to lay out forms and limit the size of single line edit controls, set corresponding local datastore storage sizes, etc. In practice, It also turns out that many tools (due to the original lack of PreparedStatement.getMetaData() in JDK 1.1) emulate a SQL_DESCRIBE by executing a query hopefully guaranteed to return no or very few rows for example: select ... from ... where 1=0. Using the dynamic scan of 1.7.2 RC5 and previous, therefore, the minimum display size value (1) was often being generated during a tool's describe phase. Upon subsequent "real" retrievals, some tools complain that CHAR and VARCHAR result values exceeded the originally reported display size and refused to fetch further values.
- Constructor Detail
  - Types
```
public Types()
```
- Method Detail
  - getParameterSQLType
```
public static Type getParameterSQLType(java.lang.Class c)
```
    Retieves the type object corresponding to the class of an IN, IN OUT or OUT parameter or a return type.
    
    Parameters:
    
    c - a Class instance
    
    Returns:
    
    java.sql.Types int value
    
    Throws:
    
    HsqlException
  - acceptsZeroPrecision
```
public static boolean acceptsZeroPrecision(int type)
```
  - requiresPrecision
```
public static boolean requiresPrecision(int type)
```
  - acceptsPrecision
```
public static boolean acceptsPrecision(int type)
```
    Types that accept precision params in column definition or casts.
  - acceptsScaleCreateParam
```
public static boolean acceptsScaleCreateParam(int type)
```
  - isSearchable
```
public static boolean isSearchable(int type)
```

Skip navigation links

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

Class Types

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

DecimalClassName

DateClassName

TimeClassName

TimestampClassName

BlobClassName

ClobClassName

SQL_CHAR

SQL_NUMERIC

SQL_DECIMAL

SQL_INTEGER

SQL_SMALLINT

SQL_FLOAT

SQL_REAL

SQL_DOUBLE

SQL_VARCHAR

SQL_BOOLEAN

SQL_USER_DEFINED_TYPE

SQL_ROW

SQL_REF

SQL_BIGINT

SQL_BLOB

SQL_CLOB

SQL_ARRAY

SQL_MULTISET

SQL_BINARY

SQL_VARBINARY

SQL_DATE

SQL_TIME

SQL_TIMESTAMP

SQL_TIME_WITH_TIME_ZONE

SQL_TIMESTAMP_WITH_TIME_ZONE

SQL_INTERVAL_YEAR

SQL_INTERVAL_MONTH

SQL_INTERVAL_DAY

SQL_INTERVAL_HOUR

SQL_INTERVAL_MINUTE

SQL_INTERVAL_SECOND

SQL_INTERVAL_YEAR_TO_MONTH

SQL_INTERVAL_DAY_TO_HOUR

SQL_INTERVAL_DAY_TO_MINUTE

SQL_INTERVAL_DAY_TO_SECOND

SQL_INTERVAL_HOUR_TO_MINUTE

SQL_INTERVAL_HOUR_TO_SECOND

SQL_INTERVAL_MINUTE_TO_SECOND

SQL_TYPE_NUMBER_LIMIT

SQL_BIT

SQL_BIT_VARYING

SQL_DATALINK

SQL_UDT

SQL_UDT_LOCATOR

SQL_BLOB_LOCATOR

SQL_CLOB_LOCATOR

SQL_ARRAY_LOCATOR

SQL_MULTISET_LOCATOR

SQL_ALL_TYPES

SQL_DATETIME

SQL_INTERVAL

SQL_XML

SQL_NCHAR

SQL_WCHAR

SQL_WVARCHAR

SQL_NVARCHAR

SQL_WLONGVARCHAR

SQL_NTEXT

SQL_LONGVARBINARY

SQL_IMAGE

SQL_GUID

SQL_VARIANT

SQL_SUB_DISTINCT

SQL_SUB_STRUCTURED

VARCHAR_IGNORECASE

ARRAY

BIGINT

BINARY