| Description |
Magic xpa Data Types - Btrieve (Magic xpa 3.x)
|
Magic xpa
Storage Type
|
Magic xpa Picture
|
Magic xpa
Storage Size
|
Btrieve
Data Type
| |
Alpha
|
|
|
| |
String
|
n,1-4088
|
n,1-4088
|
CHAR
| |
Lstring
|
n, 1-254
|
n, 2-255
|
LSTRING
| |
|
n, 255-4087
|
n, 256-4088
|
CHAR
| |
Zstring
|
n, 1-254
|
n, 2-255
|
ZSTRING
| |
|
n, 255-4087
|
n, 256-4088
|
CHAR
| |
Numeric
|
|
|
| |
Signed Integer
|
n, 1-9
|
n, 2-4
|
INTEGER
| |
Unsigned Integer
|
n, 1-9
|
n, 2-4
|
UNSIGNED
| |
Float
|
n, 1-15
|
n, 4-8
|
FLOAT
| |
Float MS-Basic
|
n, 1-16
|
n, 4-8
|
BFLOAT
| |
Float Decimal
|
n, 1-14
|
n, 4-8
|
CHAR
| |
Packed Decimal
|
n, 1-37
|
n/2+1
|
DECIMAL
| |
Numeric
|
n, 1-38
|
n, 1-38
|
NUMERIC
| |
Character Number
|
n, 1-37
|
n+1
|
CHAR
| |
String Number
|
n, 1-38
|
n, 1-38
|
CHAR
| |
Magic Number
|
n, 1-38
|
n/2+1
|
CHAR
| |
C-ISAM Decimal
|
n, 1-38
|
n/2+1
|
CHAR
| |
Extended float
|
n, 1-14
|
8
|
CHAR
| |
Logical
|
|
|
| |
Integer logical
|
n
|
n, 1-2
|
LOGICAL
| |
String logical
|
n
|
n, 1
|
CHAR
| |
Date
|
|
|
| |
Integer date
|
##/##/####
|
4
|
INTEGER
| |
Integer date - 1901
|
##/##/####
|
4
|
INTEGER
| |
String date
|
##/##/####
|
6,8
|
CHAR
| |
YYMD date
|
##/##/####
|
4
|
DATE
| |
Magic date
|
##/##/####
|
4
|
CHAR
| |
Magic date - 1901
|
##/##/####
|
4
|
CHAR
| |
Time
|
|
|
| |
Integer time
|
HH:MM:SS
|
4
|
INTEGER
| |
String time
|
HH:MM:SS
|
6
|
CHAR
| |
HMSH time
|
HH:MM:SS
|
4
|
TIME
| |
Magic time
|
HH:MM:SS
|
4
|
CHAR
| |
Unicode
|
|
|
| |
String
|
n,1-2044
|
n*2
|
WSTRING
| |
Zstring
|
n,1-2043
|
n*2+2
|
WZSTRING
|
|
Note:
|
The storage size is calculated according to the database of the table - according to the gateway's storage table. The storage size is recalculated on import.
|
|
|
|---|
