# Types Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) # Types ``` open class Types ``` |---|----------------------------------------------------------------------------------| | [kotlin.Any](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html) || | ↳ | [java.sql.Types](https://developer.android.com/reference/kotlin/java/sql/Types#) | The class that defines the constants that are used to identify generic SQL types, called JDBC types. This class is never instantiated. ## Summary | Constants || |----------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [ARRAY](https://developer.android.com/reference/kotlin/java/sql/Types#ARRAY:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`ARRAY`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [BIGINT](https://developer.android.com/reference/kotlin/java/sql/Types#BIGINT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BIGINT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [BINARY](https://developer.android.com/reference/kotlin/java/sql/Types#BINARY:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BINARY`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [BIT](https://developer.android.com/reference/kotlin/java/sql/Types#BIT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BIT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [BLOB](https://developer.android.com/reference/kotlin/java/sql/Types#BLOB:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BLOB`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [BOOLEAN](https://developer.android.com/reference/kotlin/java/sql/Types#BOOLEAN:kotlin.Int) The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type`BOOLEAN`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [CHAR](https://developer.android.com/reference/kotlin/java/sql/Types#CHAR:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`CHAR`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [CLOB](https://developer.android.com/reference/kotlin/java/sql/Types#CLOB:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`CLOB`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [DATALINK](https://developer.android.com/reference/kotlin/java/sql/Types#DATALINK:kotlin.Int) The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type`DATALINK`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [DATE](https://developer.android.com/reference/kotlin/java/sql/Types#DATE:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DATE`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [DECIMAL](https://developer.android.com/reference/kotlin/java/sql/Types#DECIMAL:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DECIMAL`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [DISTINCT](https://developer.android.com/reference/kotlin/java/sql/Types#DISTINCT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DISTINCT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [DOUBLE](https://developer.android.com/reference/kotlin/java/sql/Types#DOUBLE:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DOUBLE`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [FLOAT](https://developer.android.com/reference/kotlin/java/sql/Types#FLOAT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`FLOAT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [INTEGER](https://developer.android.com/reference/kotlin/java/sql/Types#INTEGER:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`INTEGER`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [JAVA_OBJECT](https://developer.android.com/reference/kotlin/java/sql/Types#JAVA_OBJECT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`JAVA_OBJECT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [LONGNVARCHAR](https://developer.android.com/reference/kotlin/java/sql/Types#LONGNVARCHAR:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`LONGNVARCHAR`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [LONGVARBINARY](https://developer.android.com/reference/kotlin/java/sql/Types#LONGVARBINARY:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`LONGVARBINARY`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [LONGVARCHAR](https://developer.android.com/reference/kotlin/java/sql/Types#LONGVARCHAR:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`LONGVARCHAR`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [NCHAR](https://developer.android.com/reference/kotlin/java/sql/Types#NCHAR:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NCHAR` | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [NCLOB](https://developer.android.com/reference/kotlin/java/sql/Types#NCLOB:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NCLOB`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [NULL](https://developer.android.com/reference/kotlin/java/sql/Types#NULL:kotlin.Int) The constant in the Java programming language that identifies the generic SQL value`NULL`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [NUMERIC](https://developer.android.com/reference/kotlin/java/sql/Types#NUMERIC:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NUMERIC`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [NVARCHAR](https://developer.android.com/reference/kotlin/java/sql/Types#NVARCHAR:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NVARCHAR`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [OTHER](https://developer.android.com/reference/kotlin/java/sql/Types#OTHER:kotlin.Int) 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](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [REAL](https://developer.android.com/reference/kotlin/java/sql/Types#REAL:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`REAL`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [REF](https://developer.android.com/reference/kotlin/java/sql/Types#REF:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`REF`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [ROWID](https://developer.android.com/reference/kotlin/java/sql/Types#ROWID:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`ROWID` | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [SMALLINT](https://developer.android.com/reference/kotlin/java/sql/Types#SMALLINT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`SMALLINT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [SQLXML](https://developer.android.com/reference/kotlin/java/sql/Types#SQLXML:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`XML`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [STRUCT](https://developer.android.com/reference/kotlin/java/sql/Types#STRUCT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`STRUCT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [TIME](https://developer.android.com/reference/kotlin/java/sql/Types#TIME:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`TIME`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [TIMESTAMP](https://developer.android.com/reference/kotlin/java/sql/Types#TIMESTAMP:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`TIMESTAMP`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [TINYINT](https://developer.android.com/reference/kotlin/java/sql/Types#TINYINT:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`TINYINT`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [VARBINARY](https://developer.android.com/reference/kotlin/java/sql/Types#VARBINARY:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`VARBINARY`. | | static[Int](https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-int/index.html) | [VARCHAR](https://developer.android.com/reference/kotlin/java/sql/Types#VARCHAR:kotlin.Int) The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`VARCHAR`. | ## Constants ### ARRAY Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val ARRAY: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`ARRAY`. Value: 2003 ### BIGINT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val BIGINT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BIGINT`. Value: -5 ### BINARY Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val BINARY: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BINARY`. Value: -2 ### BIT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val BIT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BIT`. Value: -7 ### BLOB Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val BLOB: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`BLOB`. Value: 2004 ### BOOLEAN Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val BOOLEAN: Int ``` The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type`BOOLEAN`. Value: 16 ### CHAR Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val CHAR: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`CHAR`. Value: 1 ### CLOB Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val CLOB: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`CLOB`. Value: 2005 ### DATALINK Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val DATALINK: Int ``` The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type`DATALINK`. Value: 70 ### DATE Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val DATE: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DATE`. Value: 91 ### DECIMAL Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val DECIMAL: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DECIMAL`. Value: 3 ### DISTINCT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val DISTINCT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DISTINCT`. Value: 2001 ### DOUBLE Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val DOUBLE: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`DOUBLE`. Value: 8 ### FLOAT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val FLOAT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`FLOAT`. Value: 6 ### INTEGER Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val INTEGER: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`INTEGER`. Value: 4 ### JAVA_OBJECT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val JAVA_OBJECT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`JAVA_OBJECT`. Value: 2000 ### LONGNVARCHAR Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val LONGNVARCHAR: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`LONGNVARCHAR`. Value: -16 ### LONGVARBINARY Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val LONGVARBINARY: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`LONGVARBINARY`. Value: -4 ### LONGVARCHAR Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val LONGVARCHAR: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`LONGVARCHAR`. Value: -1 ### NCHAR Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val NCHAR: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NCHAR` Value: -15 ### NCLOB Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val NCLOB: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NCLOB`. Value: 2011 ### NULL Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val NULL: Int ``` The constant in the Java programming language that identifies the generic SQL value`NULL`. Value: 0 ### NUMERIC Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val NUMERIC: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NUMERIC`. Value: 2 ### NVARCHAR Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val NVARCHAR: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`NVARCHAR`. Value: -9 ### OTHER Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val OTHER: Int ``` 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`. Value: 1111 ### REAL Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val REAL: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`REAL`. Value: 7 ### REF Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val REF: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`REF`. Value: 2006 ### ROWID Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val ROWID: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`ROWID` Value: -8 ### SMALLINT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val SMALLINT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`SMALLINT`. Value: 5 ### SQLXML Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val SQLXML: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`XML`. Value: 2009 ### STRUCT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val STRUCT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`STRUCT`. Value: 2002 ### TIME Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val TIME: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`TIME`. Value: 92 ### TIMESTAMP Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val TIMESTAMP: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`TIMESTAMP`. Value: 93 ### TINYINT Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val TINYINT: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`TINYINT`. Value: -6 ### VARBINARY Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val VARBINARY: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`VARBINARY`. Value: -3 ### VARCHAR Added in[API level 1](https://developer.android.com/guide/topics/manifest/uses-sdk-element.html#ApiLevels) ``` static val VARCHAR: Int ``` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type`VARCHAR`. Value: 12