Salesforce

Magic xpa Data Types - Btrieve (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Magic xpa Data Types - Btrieve (Magic xpa 4.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

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.

Reference
Attachment 
Attachment