Numeric - MSSQL (Magic xpa 4.x)
The table below lists Magic xpa’s Numeric attribute and the valid data types in MSSQL. 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.
|
|
|
|
|
|
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-39
|
n+1
|
Definition = Normal – NUMERIC
Definition = String – CHAR
* Prior to V3.1, this data type was 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.
|
