ODBC Data Types (Magic xpa 2.x)
The following table shows the results of a Get Definition operation from an ODBC table, and shows equivalents for Microsoft ODBC data types.
|
ODBC 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
|
Alpha
|
Zstring
|
Default (0)
|
Default (0)
|
|
You must set the Picture for
SQL_LONGVARCHAR datatype columns to the appropriate size for your project, after getting the table’s definition.
|
|
SQL_BIGINT
|
Numeric
|
Signed Integer
|
4
|
10
|
|
SQL_INTEGER
|
Numeric
|
Signed Integer
|
4
|
10
|
|
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 (default: 10.3)
|
|
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
|
Alpha
|
Zstring
|
N+1, 2- 256
|
n, 1-255
|
|
SQL_LONGVARBINARY
|
Blob
|
Binary Large Object
|
Default (12)
|
|
|
SQL_BIT
|
Logical
|
Integer Logical
|
1
|
5
|
|
TIMESTAMP
|
1. Date
2. Time
|
Creates two fields one with String Date and one with String Time, which are connected by the Part of Datetime property.
|
8
|
##/##/####
|
|
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.
|
