Data Types
Thursday, November 14, 2013
2:02 PM
|
Value
|
ColumnType
|
Description
|
|
++
|
|
TD_ANYTYPE
|
|
A1
|
ARRAY
|
One dimensional ARRAY data type
|
|
AT
|
TIME
|
ANSI Time
|
|
BF
|
BYTE
|
BYTE Fixed
|
|
BO
|
BLOB
|
Byte Large Object
|
|
BV
|
VARBYTE
|
Byte Varying
|
|
CF
|
CHAR
|
Character Fixed
|
|
CO
|
CLOB
|
Character Large Object
|
|
CV
|
VARCHAR
|
Character Varying Latin
|
|
D
|
DECIMAL
|
Decimal
|
|
DA
|
DATE
|
Date
|
|
DH
|
INTERVAL DAY TO HOUR
|
Interval Day To Hour
|
|
DM
|
INTERVAL DAY TO MINUTE
|
Interval Day To Minute
|
|
DS
|
INTERVAL DAY TO SECOND
|
Interval Day To Second
|
|
DY
|
INTERVAL DAY
|
Interval Day
|
|
F
|
FLOAT
|
Float
|
|
GF
|
GRAPHIC
|
|
|
GV
|
VARGRAPHIC
|
|
|
HM
|
INTERVAL HOUR TO MINUTE
|
Interval Hour To Minute
|
|
HR
|
INTERVAL HOUR
|
Interval Hour
|
|
HS
|
INTERVAL HOUR TO SECOND
|
Interval Hour To Second
|
|
I1
|
BYTEINT
|
1 Byte Integer
|
|
I2
|
SMALLINT
|
2 Byte Integer
|
|
I8
|
BIGINT
|
8 Byte Integer
|
|
I
|
INTEGER
|
4 Byte integer
|
|
MI
|
INTERVAL MINUTE
|
Interval Minute
|
|
MO
|
INTERVAL MONTH
|
Interval Month
|
|
MS
|
INTERVAL MINUTE TO SECOND
|
Interval Minute To Second
|
|
N
|
NUMBER
|
Number
|
|
PD
|
|
PERIOD(DATE)
|
|
PM
|
|
PERIOD(TIMESTAMP(n) WITH TIMEZONE)
|
|
PS
|
|
PERIOD(TIMESTAMP (n))
|
|
PT
|
|
PERIOD(TIME(n))
|
|
PZ
|
|
PERIOD (TIME(n) WITH TIME ZONE)
|
|
SC
|
INTERVAL SECOND
|
Interval Second
|
|
SZ
|
TIMESTAMP WITH TIME ZONE
|
Timestamp With Time Zone
|
|
TS
|
TIMESTAMP
|
Timestamp
|
|
TZ
|
TIME WITH TIME ZONE
|
ANSI Time With Time Zone
|
|
UF
|
|
Character Fixed Unicode
|
|
UT
|
UDT Type
|
UDT Type
|
|
UV
|
|
Character Varying Unicode
|
|
YI
|
|
Year Interval
|
|
YM
|
INTERVAL YEARTO MONTH
|
Interval Year To Month
|
|
YR
|
INTERVAL YEAR
|
Year
|
No comments:
Post a Comment