The following table provides getTypeInfo() results for MySQL 5.0.x and 5.1.

Table 1. getTypeInfo() for MySQL

TYPE_NAME = bigint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • 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
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = bigint unsigned

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = -5 (BIGINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = BIGINT
  • UNSIGNED MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 20
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = binary

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = -2 (BINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = BINARY
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = bit

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = -2 (BINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = b'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = BIT
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 64
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = blob

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = BLOB
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 65535
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = char

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = 1 (CHAR)
  • 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 = 255
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • 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
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = datetime

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = DATETIME
  • MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 19
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • 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 = 30
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 65
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = decimal unsigned

  • 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
  • UNSIGNED MAXIMUM_SCALE = 30
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 65
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

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
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = double unsigned

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

TYPE_NAME = float

  • 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 = FLOAT
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 7
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = float unsigned

  • 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 = FLOAT
  • UNSIGNED MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 7
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = integer

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • 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
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = integer unsigned

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = INTEGER
  • UNSIGNED MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = longblob

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = LONGBLOB
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = longtext

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = LONGTEXT
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = mediumblob

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = MEDIUMBLOB
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777215
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = mediumint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = MEDIUMINT
  • MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 8
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = mediumint unsigned

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = MEDIUMINT
  • UNSIGNED MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 8
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = mediumtext

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = MEDIUMTEXT
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16777215
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = smallint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • 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
  • NUM_PREC_RADIX = 10
  • PRECISION = 5
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = smallint unsigned

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 5 (SMALLINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = SMALLINT
  • UNSIGNED MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 5
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = text

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = TEXT
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 65535
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

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

TYPE_NAME = tinyblob

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = TINYBLOB
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = tinyint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • 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
  • NUM_PREC_RADIX = 10
  • PRECISION = 3
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = tinyint unsigned

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = -6 (TINYINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = TINYINT
  • UNSIGNED MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 3
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = tinytext

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = TINYTEXT
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varbinary

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = -3 (VARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = VARBINARY
  • MAXIMUM_SCALE = NULL
 
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 255
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varchar

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = 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 = 255
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = year

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 5 (SMALLINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = YEAR
  • MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 4
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true