|
Pivot
|
Condition
|
Datatype
|
|---|---|---|
|
P-AutoIdentifier
|
|
integer
|
|
P-Binary
|
|
long byte(@L)
|
|
P-Boolean
|
|
integer1
|
|
P-Byte
|
|
byte(@L)
|
|
P-Character
|
|
char(@L)
|
|
P-Currency
|
|
money(@L,@D)
|
|
P-Date
|
|
date
|
|
P-Datetime
|
|
date
|
|
P-Decimal
|
|
decimal(@L,@D)
|
|
P-Double
|
|
integer1
|
|
P-Float
|
|
float4
|
|
P-Integer
|
|
integer
|
|
P-Long Integer
|
|
integer
|
|
P-Long Real
|
|
float
|
|
P-Multimedia
|
L=2001 or L ø
|
byte(@L)
|
|
L>2000
|
long byte(@L)
|
|
|
P-Numeric
|
L>9
|
float
|
|
4<L<10
|
integer
|
|
|
L=3 or L ø
|
integer1
|
|
|
2<L<5
|
smallint
|
|
|
P-Real
|
|
float
|
|
P-Smallint
|
|
smallint
|
|
P-String
|
|
long varchar(@L)
|
|
P-Text
|
|
text(@L)
|
|
P-Time
|
|
date
|
|
P-Timestamp
|
|
date
|
|
P-Tinyint
|
|
integer1
|
|
P-Varbinary
|
|
byte varying(@L)
|
|
P-Varchar
|
|
varchar(@L)
|
|
Datatype
|
Condition
|
Pivot
|
|---|---|---|
|
byte varying(L)
|
|
P-Varbinary
|
|
byte(L)
|
|
P-Multimedia
|
|
char(L)
|
|
P-Character
|
|
date
|
|
P-Datetime
|
|
decimal(L,D)
|
|
P-Decimal
|
|
float
|
|
P-Real
|
|
float4
|
|
P-Float
|
|
integer
|
|
P-Integer
|
|
integer1
|
|
P-Tinyint
|
|
long byte(L)
|
|
P-Binary
|
|
long varchar(L)
|
|
P-String
|
|
money(L,D)
|
|
P-Currency
|
|
smallint
|
|
P-Smallint
|
|
text(L)
|
|
P-Text
|
|
varchar(L)
|
|
P-Varchar
|