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

  • 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 = BINARY
  • MAXIMUM_SCALE = NULL
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 61
  • 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
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 16
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = BYTE

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

TYPE_NAME = DATETIME

  • 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 = DATETIME
  • MAXIMUM_SCALE = 6
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 26
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 93
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = DATETIMEOFFSET

  • 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 = DATETIMEOFFSET
  • MAXIMUM_SCALE = 6
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 26
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 93
  • 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 = 38
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 3
  • 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 = 15
  • MINIMUM_SCALE = -324
  • NULLABLE = 1
  • NUM_PREC_RADIX = 2
  • PRECISION = 15
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 8
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

TYPE_NAME = GUID

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = TRUE
  • 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
  • NUM_PREC_RADIX = NULL
  • PRECISION = 36
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 1
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = INT16

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

TYPE_NAME = INT32

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

TYPE_NAME = INT64

  • 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 = INT64
  • 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 = SBYTE

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

TYPE_NAME = SINGLE

  • AUTO_INCREMENT = FALSE
  • CASE_SENSITIVE = FALSE
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 7 (REAL)
  • FIXED_PREC_SCALE = FALSE
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = SINGLE
  • MAXIMUM_SCALE = 0
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 2
  • PRECISION = 7
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = 7
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = FALSE

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

TYPE_NAME = TIMEOFDAY

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