Salesforce

Numeric - MySQL (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Numeric - MySQL (Magic xpa 4.x)

The table below lists Magic xpa’s Numeric attribute and the valid data types for MySQL. 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

MySQL Data Type

Signed Integer

n,1-4

2

SQL_SMALLINT

n, 5-9

4

SQL_INTEGER

Unsigned Integer

n, 1-2

1

SQL_TINYINT

n, 3-4

2

SQL_SMALLINT

n, 5-9

4

SQL_SMALLINT

Float

n, 1-7

4

SQL_FLOAT

n, 8-16

8

SQL_DOUBLE

Float MS-Basic

n, 1-7

4

SQL_BINARY

n, 8-16

8

SQL_BINARY

Float Decimal

n, 1-7

4

SQL_BINARY

n, 8-16

8

SQL_BINARY

Packed Decimal

n, 1-10

2*n-1

SQL_BINARY

Numeric

n ,1-18

n

SQL_BINARY

Character Number

n, 1-18

n-1

SQL_BINARY

String Number

n, 1-19

n+1

SQL_BINARY

Magic Number

n, 1-18

n/2+1

SQL_BINARY

C-Isam Decimal

n, 1-32

n/2+1

SQL_BINARY

Extended Float

n, 1-15

8

SQL_BINARY

Reference
Attachment 
Attachment