getTypeInfo()

TYPE_NAME = blob

• AUTO_INCREMENT = false
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 2004 (BLOB)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = Blob
• 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 = true

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 = 2
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = true

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

• MINIMUM_SCALE = 0 Decimal
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 38
• SEARCHABLE = 3
• 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 = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 15
• SEARCHABLE = 3
• 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 = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 7
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = int

• 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 = Int

• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 10
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = false

TYPE_NAME = localdate

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 91 (DATE)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Localdate
• 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 = true

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

TYPE_NAME = text

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = true
• CREATE_PARAMS = NULL
• DATA_TYPE = 12 (VARCHAR)
• 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 = 65536
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = true

TYPE_NAME = time

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 92 (TIME)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Time

• MAXIMUM_SCALE = 6

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 26
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = true

TYPE_NAME = timestamp

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = false
• CREATE_PARAMS = NULL
• DATA_TYPE = 93 (TIMESTAMP)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = Timestamp

• MAXIMUM_SCALE = 6

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 26
• SEARCHABLE = 3
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = true

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

• AUTO_INCREMENT = NULL
• CASE_SENSITIVE = true
• CREATE_PARAMS = NULL
• DATA_TYPE = 2009 (SQLXML)
• FIXED_PREC_SCALE = false
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = XML

• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 65536
• SEARCHABLE = 0
• SQL_DATA_TYPE = NULL
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = true