Salesforce

ODBC Data Types (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

ODBC Data Types (Magic xpa 4.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

##/##/####

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.

Reference
Attachment 
Attachment