The DatabaseMetaData.getTypeInfo() method returns information about data types. The following table provides getTypeInfo() results for supported data types.

Table 1. getTypeInfo() Results

TYPE_NAME = BigInt

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -5 (BIGINT)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = BigInt
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = Binary

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -2 (BINARY)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = X'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = Binary
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 32767
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Bit

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -7 (BIT)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = X'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = Bit
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Boolean

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 16 (BOOLEAN)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = Boolean
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Char

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 1 (CHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = Char
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Date

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 91 (DATE)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = DATE '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = Date
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 10
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Decimal

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = Decimal
  • MAXIMUM_SCALE = 1000
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 10
  • PRECISION = 1000
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = Double

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 8 (DOUBLE)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = Double
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 2
  • PRECISION = 53
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = Float

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 6 (FLOAT)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = Float
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 2
  • PRECISION = 24
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = GUID

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 1 (CHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = GUID
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 36
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Integer

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = Integer
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = JSON

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = JSON
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777215
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = LongVarBinary

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = X'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = LongVarBinary
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777215
  • SEARCHABLE = 0 (typePredNone)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = LongVarChar

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = LongVarChar
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777215
  • SEARCHABLE = 0 (typePredNone)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = NVarChar

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -9 (NVARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = NVarChar
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 32767
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = SmallInt

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 5 (SMALLINT)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = SmallInt
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 10
  • PRECISION = 5
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = Time

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 92 (TIME)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = TIME '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = Time
  • MAXIMUM_SCALE = 9
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 12
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = Timestamp

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = TIMESTAMP '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = Timestamp
  • MAXIMUM_SCALE = 9
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 23
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = TinyInt

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -6 (TINYINT)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = TinyInt
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = 10
  • PRECISION = 3
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = VarBinary

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -3 (VARBINARY)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = X'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = VarBinary
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777215
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = VarChar

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = VarChar
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1 (typeNullable)
  • NUM_PREC_RADIX = NULL
  • PRECISION = 32767
  • SEARCHABLE = 3 (typeSearchable)
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL