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 = ARRAY

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = ARRAY
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 12
  • 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 = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 16
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = CDSTYPE

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = CDSTYPE
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 18
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 12
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = CURRENCY

  • 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 = CURRENCY
  • MAXIMUM_SCALE = 2
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 18
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 3
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

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 = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 10
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 91
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = DATETIME

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 2014 (TIMESTAMP_WITH_TIMEZONE)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = TIMESTAMP '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = DATETIME
  • MAXIMUM_SCALE = 3
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 29
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 95
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

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 = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 8
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = FLOAT

  • 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 = FLOAT
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 8
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = INTEGER

  • 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 = INTEGER
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 25
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = LONG

  • 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 = LONG
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 25
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = METADATATYPE

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

TYPE_NAME = PERCENT

  • 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 = PERCENT
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 8
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = SAMPLINGLEVEL

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = SAMPLINGLEVEL
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 12
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = STRING

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = STRING
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 12
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = TIME

  • 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 = TIME
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 8
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = URL

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = URL
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 12
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL