Btrieve Databases (Magic xpa 2.x)
The following table details Magic xpa attributes with supported storage types, and the valid key length for Btrieve.
|
|
|
|
|
Alpha
|
String
|
1 - 255
|
|
Alpha
|
LString
|
1 - 254
|
|
Alpha
|
ZString
|
1 - 254
|
|
Numeric
|
Signed Integer
|
2, 4
|
|
Numeric
|
Unsigned Integer
|
1, 2, 4
|
|
Numeric
|
Float
|
4, 8
|
|
Numeric
|
Float MS-Basic
|
4, 8
|
|
Numeric
|
Float Decimal
|
4, 8
|
|
Numeric
|
Packed Decimal
|
1 - 10
|
|
Numeric
|
Numeric
|
1 - 18
|
|
Numeric
|
Numeric Character
|
|
|
Numeric
|
Numeric String
|
|
|
Numeric
|
Numeric Magic
|
2 - 20
|
|
Numeric
|
C-ISAM Decimal
|
2 - 17
|
|
Numeric
|
Extended Float
|
|
|
Logical
|
Integer
|
1, 2
|
|
Logical
|
String
|
1
|
|
Date
|
Integer Date
|
4
|
|
Date
|
Integer Date-1901
|
4
|
|
Date
|
String Date
|
6, 8
|
|
Date
|
YYMD Date
|
4
|
|
Date
|
Magic Date
|
4
|
|
Date
|
Magic Date-1901
|
4
|
|
Time
|
Integer Time
|
4
|
|
Time
|
String Time
|
6
|
|
Time
|
HMSH Time
|
4
|
|
Time
|
Magic Time
|
4
|
|
Unicode
|
Unicode String
|
254
|
|
Unicode
|
ZUnicode String
|
254
|
|
|
The Magic xpa Single User Edition does not support the Btrieve database gateway.
|
Magic xpa Data Types - Btrieve
