getTypeInfo()

TYPE_NAME = alphanum

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = -9 (NVARCHAR)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 127
• SEARCHABLE = 3
• SQL_DATA_TYPE = -9
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = bigint

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = -5 (BIGINT)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 0
• NUM_PREC_RADIX = 10
• PRECISION = 19
• SEARCHABLE = 2
• SQL_DATA_TYPE = -5
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = binary

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = -2 (BINARY)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 2000
• SEARCHABLE = 3
• SQL_DATA_TYPE = -2
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = bintext

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = NULL
• DATA_TYPE = 2011 (NCLOB)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 2147483647
• SEARCHABLE = 0
• SQL_DATA_TYPE = -10
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = blob

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = NULL
• DATA_TYPE = 2004 (BLOB)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

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

TYPE_NAME = boolean

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 16 (BOOLEAN)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 2
• SEARCHABLE = 2
• SQL_DATA_TYPE = 16
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = char

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = 1 (CHAR)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 2000
• SEARCHABLE = 3
• SQL_DATA_TYPE = 1
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = clob

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = NULL
• DATA_TYPE = 2005 (CLOB)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

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

TYPE_NAME = date

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 91 (DATE)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 10
• SEARCHABLE = 2
• SQL_DATA_TYPE = 91
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = decimal

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = precision, scale
• DATA_TYPE = 3 (DECIMAL)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 34

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

TYPE_NAME = double

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 8 (DOUBLE)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 2
• PRECISION = 52
• SEARCHABLE = 2
• SQL_DATA_TYPE = 8
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = integer

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 4 (INTEGER)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 0
• NUM_PREC_RADIX = 10
• PRECISION = 10
• SEARCHABLE = 2
• SQL_DATA_TYPE = 4
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = nchar

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = -15 (NCHAR)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 2000
• SEARCHABLE = 3
• SQL_DATA_TYPE = -8
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = nclob

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = NULL
• DATA_TYPE = 2011 (NCLOB)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

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

TYPE_NAME = nvarchar

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = -9 (NVARCHAR)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 5000
• SEARCHABLE = 3
• SQL_DATA_TYPE = -9
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = real

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 7 (REAL)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 2
• PRECISION = 23
• SEARCHABLE = 2
• SQL_DATA_TYPE = 7
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = seconddate

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 93 (TIMESTAMP)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 19
• SEARCHABLE = 2
• SQL_DATA_TYPE = 93
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = shorttext

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = -9 (NVARCHAR)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 5000
• SEARCHABLE = 3
• SQL_DATA_TYPE = -9
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = smalldecimal

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 3 (DECIMAL)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = 10
• PRECISION = 16
• SEARCHABLE = 2
• SQL_DATA_TYPE = 3000
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = smallint

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 5 (SMALLINT)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 0
• NUM_PREC_RADIX = 10
• PRECISION = 5
• SEARCHABLE = 2
• SQL_DATA_TYPE = 5
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = text

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = NULL
• DATA_TYPE = 2011 (NCLOB)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 2147483647
• SEARCHABLE = 0
• SQL_DATA_TYPE = -10
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = time

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 92 (TIME)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 0

• MINIMUM_SCALE = 0
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 8
• SEARCHABLE = 2
• SQL_DATA_TYPE = 92
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = timestamp

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = 93 (TIMESTAMP)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = 7

• MINIMUM_SCALE = 7
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 27
• SEARCHABLE = 2
• SQL_DATA_TYPE = 93
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = tinyint

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 0
• CREATE_PARAMS = NULL
• DATA_TYPE = -6 (TINYINT)
• FIXED_PREC_SCALE = 1
• LITERAL_PREFIX = NULL
• LITERAL_SUFFIX = NULL
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 0
• NUM_PREC_RADIX = 10
• PRECISION = 3
• SEARCHABLE = 2
• SQL_DATA_TYPE = -6
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = 0

TYPE_NAME = varbinary

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = -3 (VARBINARY)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 5000
• SEARCHABLE = 3
• SQL_DATA_TYPE = -3
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varchar

• AUTO_INCREMENT = 0
• CASE_SENSITIVE = 1
• CREATE_PARAMS = length
• DATA_TYPE = 12 (VARCHAR)
• FIXED_PREC_SCALE = 0
• LITERAL_PREFIX = '
• LITERAL_SUFFIX = '
• LOCAL_TYPE_NAME = NULL
• MAXIMUM_SCALE = NULL

• MINIMUM_SCALE = NULL
• NULLABLE = 1
• NUM_PREC_RADIX = NULL
• PRECISION = 65535
• SEARCHABLE = 3
• SQL_DATA_TYPE = 12
• SQL_DATETIME_SUB = NULL
• UNSIGNED_ATTRIBUTE = NULL