MySQL Data Types (Magic xpa 3.x)
The following table shows the results of a Get Definition operation from a MySQL table, and shows equivalents for MySQL data types.
|
MySQL Data Type
|
Attribute
|
Magic xpa
Storage
Type
|
Storage
Size
|
Picture
|
|
SQL_CHAR
|
Alpha
|
Zstring
|
n+1, 2- 256
|
n, 1-255
|
|
SQL_VARCHAR
|
Alpha
|
Zstring
|
n+1, 2- 256
|
n, 1-255
|
|
SQL_LONGVARCHAR
|
BLOB
|
ANSI
|
Default (0)
|
Default (0)
|
|
SQL_BIGINT
|
Numeric
|
Signed Integer
|
4
|
9
|
|
SQL_INTEGER
|
Numeric
|
Signed Integer
|
4
|
9
|
|
SQL_SMALLINT
|
Numeric
|
Signed Integer
|
2
|
5
|
|
SQL_TINYINT
|
Numeric
|
Unsigned Integer
|
1
|
3
|
|
SQL_DOUBLE
|
Numeric
|
Float
|
8
|
According to the Float property in the DBMS Properties (default: 10.3)
|
|
SQL_FLOAT
|
Numeric
|
Float
|
4
|
5.2
|
|
SQL_REAL
|
Numeric
|
Float
|
4
|
5.2
|
|
SQL_NUMERIC
|
Numeric
|
Float
|
8
|
According to the Float property in the DBMS Properties (default: 10.3)
|
|
SQL_DECIMAL
|
Numeric
|
Float
|
8
|
According to the Float property in the DBMS Properties
|
|
SQL_DATE
|
Date
|
String Date
|
8
|
##/##/####
|
|
SQL_TIME
|
Time
|
String Time
|
6
|
##:##:##
|
|
SQL_BINARY
|
Alpha
|
Zstring
|
N+1, 2- 256
|
n, 1-255
|
|
SQL_VARBINARY
|
BLOB
|
Binary
|
N+1, 2- 256
|
n, 1-255
|
|
SQL_LONGVARBINARY
|
BLOB
|
Binary
|
|
|
|
SQL_BIT
|
Logical
|
Integer Logical
|
1
|
5
|
|
TIMESTAMP
|
1. Date
2. Time
|
Creates two fields, one with String Date and one with String Time, that are connected by the Part of Datetime property.
|
8
|
##/##/####
|
|
SQLTINYBIT
|
Numeric
|
Unsigned Integer
|
1
|
|
|
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.
|
