|
Pivot
|
Condition
|
Datatype
|
|---|---|---|
|
P-AutoIdentifier
|
|
timestamp
|
|
P-Binary
|
L=0 or L ø
|
binary
|
|
L > 0
|
binary(@L)
|
|
|
P-Boolean
|
|
bit
|
|
P-Byte
|
|
bit
|
|
P-Character
|
Not Unicode and (L=0 or L ø)
|
char
|
|
Not Unicode and 0<L<256
|
char(@L)
|
|
|
L>255
|
text
|
|
|
Not Unicode and (L=256 or L ø)
|
unichar(@L)
|
|
|
P-Currency
|
|
money
|
|
P-Date
|
|
smalldatetime
|
|
P-Datetime
|
|
datetime
|
|
P-Decimal
|
0<L<39 and D not ø
|
decimal(@L,@D)
|
|
(L>9 and D ø) or ((L<1 or L>38) and D not ø)
|
float
|
|
|
4<L<10 and D ø
|
int
|
|
|
2<L<5 and D ø
|
smallint
|
|
|
L ø or (L<3 and D ø)
|
tinyint
|
|
|
P-Double
|
|
double precision
|
|
P-Float
|
|
float
|
|
P-Integer
|
|
int
|
|
P-Long Integer
|
|
int
|
|
P-Long Real
|
|
real
|
|
P-Multimedia
|
|
image
|
|
P-Numeric
|
(L>9 and D ø) or ((L<1 or L>38) and D not ø)
|
float
|
|
4<L<10 and D ø
|
int
|
|
|
0<L<39 and D not ø
|
numeric(@L,@D)
|
|
|
2<L<5 and D ø
|
smallint
|
|
|
L ø or (L<3 and D ø)
|
tinyint
|
|
|
P-Real
|
|
real
|
|
P-Smallint
|
|
smallint
|
|
P-String
|
Not Unicode and (L=0 or L ø)
|
char
|
|
Not Unicode and (0<L<256)
|
char(@L)
|
|
|
L>255
|
text
|
|
|
Not Unicode and (L=256 or L ø)
|
unichar(@L)
|
|
|
P-Text
|
|
text
|
|
P-Time
|
|
datetime
|
|
P-Timestamp
|
|
timestamp
|
|
P-Tinyint
|
|
tinyint
|
|
P-Varbinary
|
L=0 or L ø
|
varbinary
|
|
L > 0
|
varbinary(@L)
|
|
|
P-Varchar
|
L>255
|
text
|
|
Not Unicode and (L=256 or L ø)
|
univarchar(@L)
|
|
|
Not Unicode and (L=0 or L ø)
|
varchar
|
|
|
Not Unicode and 0<L<256
|
varchar(@L)
|
|
Datatype
|
Condition
|
Pivot
|
|---|---|---|
|
binary
|
|
P-Binary
|
|
binary(L)
|
|
P-Binary
|
|
bit
|
|
P-Boolean
|
|
char
|
|
P-Character
|
|
char(L)
|
|
P-Character
|
|
datetime
|
|
P-Datetime
|
|
decimal(L,D)
|
|
P-Decimal
|
|
double precision
|
|
P-Double
|
|
float
|
|
P-Float
|
|
image
|
|
P-Multimedia
|
|
int
|
|
P-Integer
|
|
money
|
|
P-Currency
|
|
numeric(L,D)
|
|
P-Numeric
|
|
real
|
|
P-Real
|
|
smalldatetime
|
|
P-Date
|
|
smallint
|
|
P-Smallint
|
|
text
|
|
P-Text
|
|
timestamp
|
|
P-Timestamp
|
|
tinyint
|
|
P-Tinyint
|
|
varbinary
|
|
P-Varbinary
|
|
varbinary(L)
|
|
P-Varbinary
|
|
varchar
|
|
P-Varchar
|
|
varchar(L)
|
|
P-Varchar
|