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

TYPE_NAME = BIGINT1

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 2 (NUMERIC)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = BIGINT
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = BIGINT
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = BINARY

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = MAX LENGTH
  • 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
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8388608
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = BINARY
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = BOOLEAN

  • AUTO_INCREMENT = NULL
  • 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
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = BOOLEAN
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = CHAR

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = MAX LENGTH
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = CHAR
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777216
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = CHAR
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = DATE

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

TYPE_NAME = DECIMAL

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = PRECISION,SCALE
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = DECIMAL
  • MAXIMUM_SCALE = 37
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = DECIMAL
  • 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
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = DOUBLE
  • 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 = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = FLOAT
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = INTEGER1

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 2 (NUMERIC)
  • 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 = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = INTEGER
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = NUMBER

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = PRECISION,SCALE
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = NUMBER
  • MAXIMUM_SCALE = 37
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = NUMBER
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = OBJECT

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

TYPE_NAME = REAL

  • 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 = REAL
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = REAL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = TIME

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

TYPE_NAME = TIMESTAMP

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

TYPE_NAME = TIMESTAMPLTZ

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

TYPE_NAME = TIMESTAMPNTZ

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

TYPE_NAME = TIMESTAMPTZ

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

TYPE_NAME = VARBINARY

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = MAX LENGTH
  • DATA_TYPE = -2 (BINARY)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = X'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = VARBINARY
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8388608
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = VARBINARY
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = VARCHAR

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = MAX LENGTH
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = VARCHAR
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777216
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = VARCHAR
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = VARIANT

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = TRUE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = VARIANT
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777216
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • TYPE_NAME = VARIANT
  • UNSIGNED_ATTRIBUTE = NULL
1 This data type is a fixed-point number type for which precision and scale cannot be specified. By default, this data type maps to NUMERIC. However, you may use the IntegerFieldMapping property to map this type and other such types to BIGINT.