Salesforce

Numeric - ODBC (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Numeric - ODBC (Magic xpa 4.x)

The table below lists Magic xpa’s Numeric attribute and the valid data types for ODBC. Each entry in the table has a default data type that can be forced by specifying that type in the Type property on the SQL section in the Column Properties sheet.

Magic xpa Storage Type

Magic xpa Picture

Magic xpa Storage Size

ODBC Data Type

Signed Integer

n,1-4

2

SMALLINT

n, 5-9

4

INTEGER

Unsigned Integer

n, 1-2

1

BINARY

n, 3-4

2

BINARY

n, 5-9

4

BINARY

Float

n, 1-7

4

REAL

n, 8-16

8

DOUBLE PRECISION

Float MS-Basic

n, 1-7

4

BINARY

n, 8-16

8

BINARY

Float Decimal

n, 1-7

4

BINARY

n, 8-16

8

BINARY

Packed Decimal

n, 1-10

2*n-1

BINARY

Numeric

n ,1-18

n

BINARY

Character Number

n, 1-18

n-1

BINARY

String Number

n, 1-19

n+1

BINARY

Magic Number

n, 1-18

n/2+1

BINARY

C-Isam Decimal

n, 1-32

n/2+1

BINARY

Extended Float

n, 1-15

8

BINARY

Note:

n is the specified picture number.

Magic xpa provides number support up to 18 digits.

Reference
Attachment 
Attachment