Hi Yingshuai,
They are different. I'd suggest you print all columns out.
Each type description has the following columns:
1 TYPE_NAME String => Type name
2 DATA_TYPE int => SQL data type from java.sql.Types
3 PRECISION int => maximum precision
4 LITERAL_PREFIX String => prefix used to quote a literal (may be null)
5 LITERAL_SUFFIX String => suffix used to quote a literal (may be null)
6 CREATE_PARAMS String => parameters used in creating the type (may be null)
7 NULLABLE short => can you use NULL for this type.
typeNoNulls - does not allow NULL values
typeNullable - allows NULL values
typeNullableUnknown - nullability unknown
8 CASE_SENSITIVE boolean=> is it case sensitive.
9 SEARCHABLE short => can you use "WHERE" based on this type:
typePredNone - No support
typePredChar - Only supported with WHERE .. LIKE
typePredBasic - Supported except for WHERE .. LIKE
typeSearchable - Supported for all WHERE ..
10 UNSIGNED_ATTRIBUTE boolean => is it unsigned.
11 FIXED_PREC_SCALE boolean => can it be a money value.
12 AUTO_INCREMENT boolean => can it be used for an auto-increment value.
13 LOCAL_TYPE_NAME String => localized version of type name (may be null)
14 MINIMUM_SCALE short => minimum scale supported
15 MAXIMUM_SCALE short => maximum scale supported
16 SQL_DATA_TYPE int => unused
17 SQL_DATETIME_SUB int => unused
18 NUM_PREC_RADIX int => usually 2 or 10
Best Regards,
Kevin Xu
-----Original Message-----
From: yingshuai...@esgyn.cn [mailto:yingshuai...@esgyn.cn]
Sent: Thursday, December 07, 2017 3:56 PM
To: dev <dev@trafodion.incubator.apache.org>
Subject: questioin about data type in trafodion
Hi Trafodioners,
i want to get data types of trafodion by jdbc metadata interface, like this:
rs = connection.getMetaData().getTypeInfo();
while (rs.next()) {
System.out.println(rs.getString(1));
}
the results are:
BIGINT
BIGINT SIGNED
CHAR
NUMERIC
NUMERIC SIGNED
NUMERIC UNSIGNED
DECIMAL
DECIMAL SIGNED
DECIMAL UNSIGNED
INTEGER
INTEGER SIGNED
INTEGER UNSIGNED
SMALLINT
SMALLINT SIGNED
SMALLINT UNSIGNED
FLOAT
REAL
DOUBLE PRECISION
VARCHAR
DATE
TIME
TIMESTAMP
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
INTERVAL
why so many INTERVAL types returned?
李英帅
易鲸捷信息技术有限公司
手机：18701691214
邮箱：yingshuai...@esgyn.cn
